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:http://lis
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 a
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 proje
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
Why does the client doing the importing need to run on Linux? Don't you have
access to a Windows machine anywhere on the network? It shouldn't matter where
the target MySQL server is or what OS it's running on.
- Original Message -
From: "Robert Morgan" <[EMAIL PROTECTED]>
To: "mysqlli
--- 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