Hey Jeff!
Thanks for the info.
Unfortunately I don't have permissions setup for this command. Our host
has disabled it because of security reasons. This was done some time ago
and they weren't willing to change then nor now.
Any other thoughts?
Oh.. one more thing.. does ANYONE know how to encapsulate ('' - single
quotes) around the values in Excel? To import data I need to do this
obviously and using a upload script I could add this into its
functionality. Thoughts?
Thanks!
Aaron
-----Original Message-----
From: jeffrey_n_Dyke@Keane.com [mailto:jeffrey_n_Dyke@Keane.com]
Sent: July 7, 2003 2:27 PM
To: Aaron Wolski
Cc: php-db@lists.php.net
Subject: Re: csv upload script?
if it is truley csv, then use MYSQL's "LOAD DATA INFILE" syntax.
granted
you've got to have ahold of the text file.....its not out of the box,
but
pretty close.
Woudl that work for you?
http://www.mysql.com/doc/en/LOAD_DATA.html
hth
Jeff
"Aaron Wolski"
<aaronjw@martekbi To:
<php-db@lists.php.net>
z.com> cc:
Subject: csv
upload script?
07/07/2003 02:17
PM
Hey all,
Does anyone know a simple.. out of the box ready go csv upload script to
import values into a table?
I've looked at hotscripts and couldn't find anything.
Any help is appreciated.
Thanks!
Aaron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
