Insert from CSV (comma separated values) file ? 
Author Message
 Insert from CSV (comma separated values) file ?

I need to insert some values from a CSV file. It's a little more complicated than
that since I have to do a SELECT query (from one table) on one of the values to get
the proper value for the INSERT query (into another table)

I'd like it to be some kind of script that I could set up as a cron job

This sounds like the kind of things that somebody may have already done - can
anyone point me to it? I'd prefer bash or perl scripts

I checked google but couldn't come up with anything

---------------------------(end of broadcast)---------------------------



Tue, 05 Jul 2005 06:39:07 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. How to import CSV (comma separated value) ascii file

2. Batch Updating from an CSV (Comma-separated values) file

3. Importing "comma separated value" files

4. Reading Comma Separated Value File Data Into ADO

5. BCP with Comma Separated Value files

6. comma separated values in column

7. Parsing comma separated or delimited values

8. Help Inserting values from a CSV file into an Oracle table

9. How to get comma separated values using select statement

10. DTS import error from CSV file - cannot insert value NULL

11. Help need to split comma separated string into distinct values and count for each

12. SqlLoader and Concatenation of Comma separated values


 
Powered by phpBB® Forum Software