How do you use a quoted csv with bulk insert ? If you set the FIELDTERMINATOR = ',' it will insert the quotes and if you set it to '","' you still get a quote on the first and last column. Colin Robinson Senior Analyst Programmer In-tuiton.co.uk +44 1825 746400 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
