The TSQL of CSV: Comma-Delimited of Errors
Posted by: Simple Talk,
on 13 Apr 2012 |
View original | Bookmarked: 0 time(s)
Despite the neglect of the basic ODBC drivers over the years, they still afford a neat way of reading from, and writing to, CSV files; and to be able to do so in SQL as if they were tables is somewhat magical. Just to prove it is possible, Phil creates a CSV version of AdventureWorks as a linked server....