Re: importing Access databases

2003-07-28 Thread SpamBox
Robert Morgan wrote: Hi, I'm doing a project for a local hospital, they want to migrate their access databases to mysql on a Linux box. The hospital runs a Windows network and I have MYsql running on a linux box connected to the network. I need to import the Access .mdb data and structure from

RE: importing Access databases

2003-07-28 Thread electroteque
there is an app called sqlyog it imports access directly into mysql -Original Message- From: SpamBox [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 7:13 AM To: Robert Morgan; mysqllist Subject: Re: importing Access databases Robert Morgan wrote: Hi, I'm doing a project

Re: importing Access databases

2003-07-28 Thread Andreas
Robert Morgan wrote: Hi, I'm doing a project for a local hospital, they want to migrate their access databases to mysql on a Linux box. Depends how big the whole thing is as well as how good the current design is. Since it is running in a hospital I hope the Access approach was propperly done

Re: importing Access databases

2003-07-28 Thread Bob Ramsey
I saw a macro for access that will produce a script that will recreate your tables and the data in them. But it only worked in older versions of access. Sorry I can't be more help. bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

importing Access databases

2003-07-27 Thread Robert Morgan
Hi, I'm doing a project for a local hospital, they want to migrate their access databases to mysql on a Linux box. The hospital runs a Windows network and I have MYsql running on a linux box connected to the network. I need to import the Access .mdb data and structure from the windows server to

Re: importing Access databases

2003-07-27 Thread Sanya Shaik
--- Robert Morgan [EMAIL PROTECTED] wrote: Hi, I'm doing a project for a local hospital, they want to migrate their access databases to mysql on a Linux box. The hospital runs a Windows network and I have MYsql running on a linux box connected to the network. I need to import the Access .mdb

Re: importing Access databases

2003-07-27 Thread Jim McAtee
[EMAIL PROTECTED] Sent: Sunday, July 27, 2003 1:14 PM Subject: importing Access databases Hi, I'm doing a project for a local hospital, they want to migrate their access databases to mysql on a Linux box. The hospital runs a Windows network and I have MYsql running on a linux box connected