I have space on a server on the internet. I have mySQL & PHP4 support. And i can easily upload the .CSV files on the server itself. Could you kindly help me out with the php code that would make this possible..
Thanks, T. Edison jr. --- Rick Emery <[EMAIL PROTECTED]> wrote: > The file is located on the server and you have > access to it, yes. If the > file is on the client, then no > > -----Original Message----- > From: Thomas Edison Jr. > [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 12, 2002 12:21 PM > To: Rick Emery > Subject: RE: [PHP] Re-Importing .CSV file into > Database > > > HI, > > Thanks.. i will try this. But tell me, can this same > be executed through a php page rather than the mySQL > command line? > > T. Edison Jr. > > --- Rick Emery <[EMAIL PROTECTED]> wrote: > > look at MYSQL's LOAD DATA INFILE command: > > > > LOAD DATA INFILE "datafile.csv" INTO mytable > FIELDS > > TERMINATED BY ',' > > OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY > '\n' > > > > -----Original Message----- > > From: Thomas Edison Jr. > > [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, February 12, 2002 12:02 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP] Re-Importing .CSV file into > Database > > > > > > Glory! > > > > I have a bunch of .CSV (Microsoft Excel Comma > > Seperated Values) Files with me, whose data i want > > to > > put back into my mySQL database tables. How can i > do > > that through php? or otherwise... > > > > thanks, > > T. Edison jr. > > > > > > ===== > > Rahul S. Johari (Director) > > ****************************************** > > Abraxas Technologies Inc. > > Homepage : http://www.abraxastech.com > > Email : [EMAIL PROTECTED] > > Tel : 91-4546512/4522124 > > ******************************************* > > > > __________________________________________________ > > Do You Yahoo!? > > Send FREE Valentine eCards with Yahoo! Greetings! > > http://greetings.yahoo.com > > > > -- > > 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 > > > > > ===== > Rahul S. Johari (Director) > ****************************************** > Abraxas Technologies Inc. > Homepage : http://www.abraxastech.com > Email : [EMAIL PROTECTED] > Tel : 91-4546512/4522124 > ******************************************* > > __________________________________________________ > Do You Yahoo!? > Send FREE Valentine eCards with Yahoo! Greetings! > http://greetings.yahoo.com ===== Rahul S. Johari (Director) ****************************************** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 ******************************************* __________________________________________________ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
