RE: About transferring database

2002-08-30 Thread Kerry Ancheta
Hasan, You can use MyODBC for this. Kerry -Original Message- From: Hasan Ozduru [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 10:35 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: About transferring database Dear MySQL company, How can I

Re: About transferring database

2002-08-14 Thread David Frischknecht
Hasan, The only way I was able to do this was by creating a database in MySQL with the tables set up the same way as those in Access, exporting each table in Access to a separate CSV file, and then using LOAD DATA INFILE ... to import the data from the CSV files into the tables. Good luck.