Which is easier to convert to MySQL? Access or SQL2000?

2 views
Skip to first unread message

W i l l

unread,
Oct 1, 2001, 8:22:11 PM10/1/01
to
Which is easier to convert to MySQL? Access or SQL2000?

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.

Starduck

unread,
Oct 2, 2001, 3:10:11 AM10/2/01
to
In article <l92irtoih9k6ugcla...@4ax.com>, W_i...@me.com
says...

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 !"

Justin Koivisto

unread,
Oct 2, 2001, 11:38:03 AM10/2/01
to

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 Ghonim

unread,
Oct 3, 2001, 1:51:23 AM10/3/01
to
Well,
I've experienced the same problem 6 months ago, It was a headeche for me
however I guess now I would know the solution.
Acess allows you to dump the database, make a table structure in your Mysql
the same as the one that you have for the Access Database.
Dump all the data putting : "" between every field ( you can choose that )
( Ex.: "1","John","Woow" )
After that you can easily create your Mysql Database and dump the files to
it.

Wael
Islam = Terrorism ?!
http://english.islamway.com

"W i l l" <W_i...@me.com> wrote in message
news:l92irtoih9k6ugcla...@4ax.com...

Reply all
Reply to author
Forward
0 new messages