Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Cannot easily bulk insert from CSV file with double quotes
Hi simian, This is why I am going to pre-process the CSV file so all the string fields which may contain a comma will be surrounded by double quotes.- surfoman
- Post #5
- Forum: Microsoft SQL Server: Programming
-
Cannot easily bulk insert from CSV file with double quotes
Hi George, I realise now that I will need to pre-process the CSV file to insert the double quotes so the data is consistent as you say. This whole process needs to be done automatically on a weekly scheduled basis so having to manualy take the file and convert is not practical.l My solution...- surfoman
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Cannot easily bulk insert from CSV file with double quotes
I am trying to bulk insert from a comma separated CSV file containing double quotes. Here is an example CSV file which illustrates what I am referring to: --------------------------- ID,TextField1,TextField2 23,This is some text for this field,This is some other text 34,”This field, contains...- surfoman
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
Why does 'xmlDom.preserveWhiteSpace = True' cause this error?
Does anyone know why I keep getting this error - 'Property let procedure not defined and property get procedure did not return an object' , for the code below, it seems to have occured since I added the line ' xmlDom.preserveWhiteSpace = True', thanks for any help...- surfoman
- Thread
- Replies: 0
- Forum: Microsoft: Access Modules (VBA Coding)
