I will be hosting a web app on MySQL but I can only get the DB in
either Access or SQL2000 format.
Any help would be appreciated.
I had about the same problem. I solved this by creating a small VB
program which dumped all the MS Access records in a text file.
In MySQL I created a table with the same structure as the Access
database. Then I used the MySQL command LOAD DATA INFILE to copy the
records from the text file into the MySQL database.
I am a newbie myself, so there might be better solutions for this, like
ODBC.
--
"minds are like parachutes, they only work when open !"
if you can export to cvs files, then you shouldn't have many problems at
all - especially if you read about importing file formats in the mysql
documentation
--
Justin Koivisto
jus...@wafishermn.com
Wael
Islam = Terrorism ?!
http://english.islamway.com
"W i l l" <W_i...@me.com> wrote in message
news:l92irtoih9k6ugcla...@4ax.com...