I use OPENROWSET to load excel files with variable number of columns to SQL tables. However, the
columns created in the table have names starting from F1,F2 and so on. Is there a way to define the column names in the SQL table according for example to the first row of excel file?
The excel file has the format :
Col1 Col2 Col3 Col4 Col5 .....
xx yy zz 11 22
I want the created column names using openrowset to be Col1, Col2 etc....Not F1, F2.....
Thanks in advance,
View Complete Post