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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: July 7, 2003 2:27 PM
To: Aaron Wolski
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] 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"

                      <[EMAIL PROTECTED]        To:
<[EMAIL PROTECTED]>

                      z.com>                   cc:

                                               Subject:  [PHP-DB] 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

Reply via email to