Dear Steve,
> Is it possible to export data from MS Access into MySQL?
If you don't care to export every single table manually, this is what
you do:
1. Install MyODBC 3.51.04
2. Configure a system DSN for your MySQL server.
3. In Access, right-click the table to be exported.
4. Choose Export...
r 26, 2002 12: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 i
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 dat
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
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
A quick way. If you don't have phpMyAdmin running set it up. It has a great
import feature. Just dump the access table to a delimited text file. Then go
to phpMyAdmin, from the main page - create a new database, or select an
existing one. from there scroll down to create a table, enter the table na
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
age-
> 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 whe
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Steve,
It is quite possible. You can use MyODBC to connect your current
Access database(s) into your MySQL server directly, the major
drawback is that you'd have to create the overall table structure in
MySQL first and then link the table from MySQL
I ran across several quick and dirty, but very effective little
converters at this site:
http://www.intranet2internet.com
Regards,
Jim
Jim Esten
Chief Techbot
WebDynamic http://www.wdynamic.com
-Original Message-
From: Steve Jackson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November
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 Acce
11 matches
Mail list logo