Re: [PHP-DB] csv upload script?

2003-07-07 Thread jeffrey_n_Dyke 

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

RE: [PHP-DB] csv upload script?

2003-07-07 Thread Aaron Wolski 
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