Using Sql To Query An Excel Worksheet Without A Header Row

I have been searching for a solution for a while, and I find myself coming up empty handed. The question is: Can you build a SQL query against a worksheet if you don't have a disti

Solution 1:

You can go through this link:

http://www.sql-server-helper.com/tips/read-import-excel-file-p02.aspx

Providing the HDR attribute as NO, will automatically name the columns as F1 to Fn.