I would load csv into temp table. that way you can loop and use the data from the temp table for inserts into the product table more efficiently you could then empty the temp table after the action is performed. csmith
-----Original Message----- From: Wayne Irvine [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 1:18 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Import CSV > Does the database that you are importing to able to import CSV format? Have > you tried just uploading file as is then automate the database import? I'm not directly importing to the database. The database contains all sorts of product information. The data file is product code, current stock level, and some other guff such as title and genre. The task is to go through each record in the data file and see if there is a corresponding record in the db. If there is then we update the stock value (and ignore all other fields). If there isn't we add a new record. Someone must have developed a solution for CSVs. I guess I could parse the file and replace all commas occuring after an even number of " but it does seem rather archaic and probably redundant. Wayne Byte Services Pty Ltd http://www.byteserve.com.au/ [EMAIL PROTECTED] Ph 02 9960 6099 Mob 0409 960 609 Fax 02 9960 6088 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf