I’m trying to use the wizard to import some data from an Excel spreadsheet but receive the following error and no lines are imported.
Thread (12) Import Started [25/03/2011 11:46:20]
Thread (12) Processing “SM Address Details - Work.xlsx” into “vpmserTransferTest.dbo.a_cli”
Thread (12) Truncate table vpmserTransferTest.dbo.a_cli
Thread (12) Reading from file SM Address Details - Work.xlsx
Thread (12) Error importing data, please check file format options: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
If i use the exact same options within Management Studio the import routine runs fine and all data is imported as expected.
I’ve tried it using .xls and .xlsx with no joy.
Any help would be much appreciated
Thanks in advance