Excel import error

[limez0r]

I am desparate for assistance! Cannot figure out what it going on.

Ill trying to import an excel spreadsheet thusly

DoCmd.TransferDatabase acImport, acSpreadsheetTypeExcel12, table1, acTable, "C:\test.xls"

Plain and simple, done it hundreds of times years ago, however I am getting this error:

Run-time error '2507': The 9 type isn't an installed database type or doesn't support the operation you chose.

How can this be? I have Excel 2007 installed? I have googled everything I can think of and found no other example of this error in relation to Excel... I have switched on all the main reference librarys I can think of, and when I search the object library for "acSpreadsheetTypeExcel12" it shows up, however nothing comes up as a list option for database type, the way I remember it used to. (eg; the way vb pops up a list of selectable constants) It does pop up for transfer type however.

I am at a loss. Without this function I cannot continue!

[limez0r]

Should be DoCmd.TransferSpreadsheet my mistake.