From previous experience with this problem - the most 'relaible' method for me was to
(1) use the access/xls/whatever application to dump a CSV-type file
(2) upload the file to the appropriate location on your MySQL server
(3) write a PHJP script that use a standard LOAD DATA INFILE query.
From the MySQL Docs
-------------------------------------
7.15 LOAD DATA INFILE syntax
LOAD DATA [LOW_PRIORITY] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]]
[LINES TERMINATED BY '\n']
[IGNORE number LINES]
[(col_name,...)]
The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed. If the LOCAL keyword is specified, the file is read from the client host. If LOCAL is not specified, the file must be located on the server. (LOCAL is available in MySQL 3.22.6 or later.)
-------------------------------------
HTH
Tom Henry
Rick Emery wrote:
try GOOGLE: access mysql php conversion
I did
----- Original Message ----- From: "Edward Peloke" <[EMAIL PROTECTED]>
To: "PHP general list" <[EMAIL PROTECTED]>
Sent: Tuesday, January 14, 2003 8:48 AM
Subject: [PHP] data move, Please Help..
Ok, I know I have asked this question before and I have asked it on the db
forum, on asp forums, java applet forums, searched google, etc but can't
really seem to find anything. I have to come up with a way to move data
from an access db to the mysql db on the webserver. If I have to, I can
upload the access file to the server and then transfer the data. Are there
tutorials or samples somewhere of how to do this in php?
Best case scenario would be to come up with a way (using any tool, java,
activex, etc) to connect to the users machine and then upload the data
directly from there.
ANY help would be greatly appreciated!
THANKS,
Eddie
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
