Unanswered: Importing from Excel not getting all data
I've tried using DTS, OpenDataSource & OPENROWSET to import an Excel sheet without complete success. The import works, but some of data in the columns on the Excel sheet imports as nulls or in the case of data like 110982/3 imports to 36994.
There is mixed data on all the columns with Text and numbers. So, I've tried formating the Excel cells to TEXT but that doesn't help.
Is there some way to force the import to use the data the way it is on the sheet whether than interpreting it to another data type or whatever SQL Server is doing?