I am desparate for assistance! Cannot figure out what it going on.
Ill trying to import an excel spreadsheet thusly
Code:
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!