thanks Tom! I will play with this. I just don't want to ask the users to export the file to xls first, just want to have them hit a button and the data is uploaded...
Eddie -----Original Message----- From: TomH [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 4:07 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] 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" <[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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
