RE: [PHP] Importing Text into Database - Can you recommend a tutorial?
| From: | Giz | Date: | Sat, 24 Jan 2004 02:24:01 +0000 |
| Subject: | RE: [PHP] Importing Text into Database - Can you recommend a tutorial? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-175607@lists.php.net to get a copy of this message | ||
CSV just stands for comma separate values. CSV support is pretty common as
a way of moving data between applications, and most all spreadsheets support
it. It's just a text file like this:
Value1,value2,value3
Sometimes you might have a string delimiter like so:
Value1,value2,"string 1 here",value3
-----Original Message-----
From: Freedomware [mailto:david_blomstrom@yahoo.com]
Sent: Friday, January 23, 2004 5:23 AM
To: php-general@lists.php.net
Subject: Re: [PHP] Importing Text into Database - Can you recommend a
tutorial?
Jay Blanchard wrote,
"Ooops, sorry. Google for 'import CSV into MySQL' or hit the MySQL web
site"
Humberto Silva wrote:
> You can pick the headers from the speadsheets to construct the tables,
> export from the spreadsheets to .csv and import it to the new tables
Wow, thanks for the tips. I wasn't even aware of CSV - something that
will be very useful for me.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php