Importing only 3 columns of .xls

[leeloo0505]

Hello,

I am writing a macro in Access 2000 on XP Pro (not VBA) and I am having trouble specifying the range to import.
I got everything working but I only want three columns, A, B, and C not all. In Access, when setting up the macro with TransferSpreadsheet as the Action, the last cell is Range: I have tried entering all kinds of ways like
A:A, B:B, C:C or A:A; B:B; C:C and it comes back with an error saying 'unable to find object'. I have tried A:A and that works so I know I am on the right track??

Thanks,
leeloo

 

[leeloo0505]

Actually sorry, this will make a difference.. I need column A, B and D not C. A:D will work but just trying to avoid the column C if anyone knows what Access is looking for.

leeloo