RE: [PHP] Importing MS Access into MySQL?
| From: | Jon Snell | Date: | Mon, 29 Jan 2001 22:47:50 +0000 |
| Subject: | RE: [PHP] Importing MS Access into MySQL? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-37163@lists.php.net to get a copy of this message | ||
There are a few ways to do this...
1) Save your data to a comma separated list and use the import features of
mysql. This is the easiest option for one time use.
2) Use MyODBC, create a link table, and paste the rows into it. This is one
of the easier options if you plan on doing it repeatedly.
Jon Snell
-----Original Message-----
From: James, Yz [mailto:liljim@btconnect.com]
Sent: Monday, January 29, 2001 3:46 PM
To: php-general@lists.php.net
Subject: [PHP] Importing MS Access into MySQL?
Hey all,
I heard somewhere (I think) that it's possible to import a Microsoft Access
file (when saved as a delimited text file) into a MySQL table.... Just
wondering whether or not this is true, and if it is, where I might find a
tutorial / some literature on how I might go about doing it.
Thanks, as always, in advance :)
James.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net