July 3rd, 2000, 06:59 AM
|
|
Contributing User
|
|
Join Date: Feb 2000
Location: Den Laeghe Landen
Posts: 107
Time spent in forums: 2 m 49 sec
Reputation Power: 9
|
|
|
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by des:
Does anyone know how to import MS Access databases (.mdb) into mysql
Thanks
Des[/quote]
Export table from MS-access into a text-file.
maybe you need to adapt it a little bit (add quotes around strings etc.)
but this is only possible if there aren't too many data.
read the text-file into mysql
Another way (if you often have to import data, or a lot data):
make a php-script, which reads the text-file (or paste the text into a variable) and make php read it line-by-line, and parse it at the separation-tokens used in the files (komma or tab, etc) with explode or implode (see php-man) and for each line insert int into your table.
Good luck!
EyE
------------------
--
...tiktak...tiktak...
--
...Tommyknockers, Knocking On Your Door...
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
