Importing CSV with optional double quote text qualifier
In this post, I hope to show how to load in a CSV (comma-separated values) flat-file with an optional double quote (“) text qualifier and a XML format file using BULK INSERT and OPENROWSET.
In this post, I hope to show how to load in a CSV (comma-separated values) flat-file with an optional double quote (“) text qualifier and a XML format file using BULK INSERT and OPENROWSET.