Is it possible to export data from MS Access into MySQL?
If so how?
I have a huge amount of data that will take weeks to input and I've
convinced my boss to use MySQL rather than any other DB because of it's
compatibility with PHP. However I (probably hastily) *assumed* that
there would be a way
Download MySQL-Font v2.5
This is what I used when I switched from Access to MySQL.
Once installed just load MySQL-Front and click on Im-/Export on the toolbar. Select
ODBC Import.
Viola!
On Tue, 26 Nov 2002 16:37:45 +0200, Steve Jackson wrote:
Is it possible to export data from MS Access
26, 2002 8:38 AM
To: MySQL General Mailing list
Subject: Is it possible to export data from access to MySQL?
Is it possible to export data from MS Access into MySQL?
If so how?
I have a huge amount of data that will take weeks to input and I've
convinced my boss to use MySQL rather than any other
- -Original Message-
From: Steve Jackson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 8:38 AM
To: MySQL General Mailing list
Subject: Is it possible to export data from access to MySQL?
Is it possible to export data from MS Access into MySQL?
If so how?
I have a huge amount of data
-
From: FlashGuy [mailto:[EMAIL PROTECTED]]
Sent: 26. marraskuuta 2002 16:42
To: MySQL General Mailing list; [EMAIL PROTECTED]
Subject: Re: Is it possible to export data from access to MySQL?
Download MySQL-Font v2.5
This is what I used when I switched from Access to MySQL.
Once
MySQL-Front is quite good for this...
- Original Message -
From: Steve Jackson [EMAIL PROTECTED]
To: MySQL General Mailing list [EMAIL PROTECTED]
Sent: Tuesday, November 26, 2002 4:37 PM
Subject: Is it possible to export data from access to MySQL?
Is it possible to export data from MS
teach them how to program, you will frustrate them for a lifetime.
-Original Message-
From: Steve Jackson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 9:38 AM
To: MySQL General Mailing list
Subject: Is it possible to export data from access to MySQL?
Is it possible to export
Hi!
Yes, it's possible. Export your Access data to standard csv files, and then
use mysqlimport with appropriate parameters to import the csvs into MySQL.
The MySQL manual has excellent guidance on using mysqlimport or LOAD DATA
INFILE statements (which can do the same as mysqlimport).
Iikka
On
I used MyAccess to convert my 40mb .mdb file into MySQL and it works
great. You can find it and a whole bunch of other conversion tools on
the MySQL site in Downloads/Other. Here's the link,
http://www.mysql.com/downloads/os-win32.html
Good Luck
Steve Jackson [EMAIL PROTECTED] 11/26/02 6:37:45
you're gonna get lots of neat high tech answers
to your problem, so here's a low tech answer just
because it's fun.
construct the database in mysql.
copy the access database to a working copy to be
safe.
in the working copy, link to the mysql tables.
open the access table a and copy the
:50 PM
To: MySQL General Mailing list; [EMAIL PROTECTED]
Subject: Re: Is it possible to export data from access to MySQL?
you're gonna get lots of neat high tech answers
to your problem, so here's a low tech answer just
because it's fun.
construct the database in mysql.
copy the access
[EMAIL PROTECTED]
To: MySQL General Mailing list [EMAIL PROTECTED]
Sent: Tuesday, November 26, 2002 3:37 PM
Subject: Is it possible to export data from access to MySQL?
Is it possible to export data from MS Access into MySQL?
If so how?
I have a huge amount of data that will take weeks
12 matches
Mail list logo