SQL Server bulk insert - embedded commas?
It is a reasonably simple task that I have been unable to achieve otherwise.
I am receiving data extracts from an ERP system that provides records in comma delimited format only. However, the data fields contain commas as well.
I am importing the data into SQL Server using the bulk insert method. Bulk insert is very simple and does not interpret the commas in the data fields correctly, even though the fields containing the commas are surrounded by double quotes.
I have used TextPipe to convert Comma delimited to Tab delimited files, which has been successful. I will eventually run TextPipe in command line mode to enable the whole process to run on batch mode.