RE: [PHP-DB] copying data
| From: | HP-Richardson,ex1) | Date: | Thu, 12 Dec 2002 16:24:04 +0000 |
| Subject: | RE: [PHP-DB] copying data | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-24094@lists.php.net to get a copy of this message | ||
yes, if your server is windows based.
Create a odbc system dsn to the access file on your server, then connect to
that dsn. You can then pull data from it, connect to mysql and insert the
data.
If I remember correctly, you had wanted your users to upload the mdb file
for you to extract the data. This may be tricky as I am not sure if you can
bait and switch the file from under the odbc connections nose.
Cheers
Jason
-----Original Message-----
From: epeloke@echoman.com [mailto:epeloke@echoman.com]
Sent: Thursday, December 12, 2002 10:33 AM
To: PHP-DB
Subject: [PHP-DB] copying data
I asked a question sort of alone these lines the other day so please forgive
me if it sounds familiar...
If I have a microsoft access file .mdb on my server, can I use a php page
to move the data from the file to a mysql db?
Thanks,
Eddie
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php