|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Be the architects of evolution and help create the mobile internet future. It’s your move---enter to win here! |
|
#1
October 25th, 1999, 11:44 AM
|
|||
|
|||
|
I'm a newbie to mySQL so I'm hoping somebody could help me by shedding some light on converting Access dbs to mySQL. I know there are scripts available, but some help maybe on getting them to work?
|
|
#2
November 1st, 1999, 02:07 AM
|
|||
|
|||
|
Check out for the Access VBA script at http://www.cynergi.net/exportsql/. It would be too long to include here. I dit not test it myself yet. It should work under both Access 97 and 95. Otherwise, see also MySQL command LOAD_DATA_INFILE for loading text files.
|
|
#3
November 1st, 1999, 04:57 AM
|
|||
|
|||
|
try and copy the access database as an txt file...(cut and copy from the browse mode)...now u will have ur data in the space seperated form...use the load data infile syntax in MYSQL to load file...
u can also use the exportsql file mentioned above...u have to use it as an macro... it will create a mysqldump.txt which u will ahve to execute in mysql... both the ways r good ...thougth u may try teh previous one for fast transfer... [This message has been edited by Sumeet Sharma (edited 11-01-99).]
|
|
| Viewing: Dev Shed Forums > Databases > MySQL Help > MS Access to mySQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
