Here's the problem:
I have an excel sheet that has a list of tasks on the left side and then people's names going across the top. Under each person's name is a list of numbers.
I want to import this list into SQL which should be no big deal. The first cell has some text about that the spreadsheet so I am unchecking the "first row has column names" checkbox. When I get the data in the columns that has the people's names, it gets imported as a float. So I get all the numbers and none of the names. I am using a basic data import in SSMS.
I have also tried importing using SSIS and trying to converting the data but the data doesn't even make it to the convert stage. I tried changing the column name in the excel spread sheet but that didn't work either.
I tried the reg change too. Found that one here:
I also tried querying the spread sheet and got this beauty:
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
This is from Excel 2003 .xls to SQL 2008 R2 dev.
Any help would be appreciated.