Import Wizard Error

Toad for SQL Server
1

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

Karl

2

Karl,

can you send me your xlsx file? Or let me know how the data in your file is formatted?

3

No problem Valentine, can you message me your email address please and i’ll get it sent over

Thanks in advance

Karl

4

Karl, here you go: valentin (dot) baev (at) quest (dot) com

Many thanks in advance!

5

…

6

there is no “e” on the end.

7

All sorted

8

I’ve also had this problem. I’ve found that the problem usually is
the spreadsheet layout and table do not match. It’s seems to be the
spreadsheet has a column that the table does not.