Import full access dbase to mysql?

[elemental]

Hey there. I've got an access 2000 database and have exported it to .txt is there a way I can import the entire thing into mysql or do I just have to import each table?
Thanks
elemental

 

[sleipnir214]

I do not know of an app capable of importing and entire Acess database at one go.

Most Win32-based MySQL management GUI apps have the cabability to use ODBC to pull the data from an Access database table and insert those records into a MySQL table.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[ToeShot]

I have a program that will create a script that will create your access database in MySql. The Bad part. This is a demo piece of software and limits itself to 5 tables. I f you want it give me your email address and I will send it to you. It is about 1 meg

Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait

 

[ToeShot]

I have put the program on my website that I am trying to get up so you can get it here

http://www.access4cheap.com/~toeshot/index.html

Dave
ToeShot@Hotmail.com
Today Is Tomorrows Yesterday. So Why Wait

 

[QatQat]

Perhaps I did not understand elemental's post correctly but it seems to me that he has exported a .txt file from access. I am not aware of access exporting any other way than 1 table at the time into .txt. so definitely you will have to

LOAD DATA INFILE...... for each table.

Otherwise, read Sleipnir214 reply.


Bye


Qatqat

I have been happy throughout my life in thinking that samba was I kind of dance; now I live with Linux and all I do is working.