Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask

(Robert Sheldon) It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or linking to the spreadsheet as a server. The problem is that there are certain things that aren’t obvious that you need to know about, and you feel awkward about asking su

Read More - Register for Free Membership