Macro transfer spreadsheet, error

[Delboy14]

Excel & Access 2003

I have set up a simple macro to import data from a spreadsheet, appending it to an existing table in my database.

The macro uses action "TransferSpreadsheet" with arguments
Transfer Type: Import
Spreadsheet Type: Microsoft Excel 8-10
Table Name: CONTACT
File Name: H:\RR.xls
Has Field Names: No
Range: O_RRTODAY!A111

When ran I receive an error which reads "Field 'F1' doesn't exist in destination table 'CONTACT'" I do not understand why this is happens I have a range which does not include F1 and the field includes not data anyway.

Does anyone understand why this error is occuring?

 

[PHV]

Has Field Names: No
So, the fields are named F1, F2, ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886