AIL PROTECTED]>
>Subject: Re: Access Database into mysql
>
>Hi there,
>
>I had to do the same thing.
>I guess I did it the hard way since I didnt have any modules or perl.
>It took me some time to figure it out and I wrote a little procedure:
>
>[schnipp]
>
>3. Loa
You should be able to export data directly from Access to a delimited text
file.
Curtis
On Thu, 7 Jun 2001, Ute Hoffmann wrote:
> Hi,
>
> I have a database table, which was made with Microsoft Access and am to move
> the data into a mysql database table. As there are some long entries, which
> Hi,
>
> I have a database table, which was made with Microsoft Access and am to move
> the data into a mysql database table. As there are some long entries, which
> exceed the data size allowed in a table cell by Microsoft Excel I can't
> export it via Excel and convert it from Excel into a
If you are familiar with perl, try using DBD::ODBC module to pull
the data out of Access and use the DBD mysql modules to write the
data to mysql. You will have to set up the table structure in
mysql to match your Access.
-Original Message-
From: Ute Hoffmann [mailto:[EMAIL PROTECTED]]
Hi there
I am succesfully using DB Tools, you can find it on the MYSQL web site. It
works perfectly, you just need to change your date columns, as when it
imports, it imports as a DateTime (because that is how access works), and I
wanted Date only columns.
Otherwise works like a dream
Cheerio
