I want to load data from Excel file to SQL Server. I can't use
"Import/Export", so I added a linked server in SQL Server.
One of the columns in Sheet1 (Excel File) is something like:
But when I execute the following query in Query yzer:
select * from ExcelSource...Sheet1$
The column gives me:
How can I specify the data type of an Excel file? I tried to "Format Cells"
in Excel and set it to "Text", but it didn't work. It does work if I double
click each cell. ...