Re: data move, Please Help..

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" <epeloke@echoman.com> To: "PHP general list" <php-general@lists.php.net> 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