Import Excel spreadsheet with Macro getting missing F1 field

[was1]

I'm trying to import an Excel spreadsheet into Access using the Macro function. I keep getting an error message that "F1" field is not in the destination table. I tried deleting the columns to the right of my last populated column but still get that message.

Does any one know what I can do to fix it?

 

[bubba100]

I use VBA not macro's but here are a couple of things.

Are you trying to import into an existing table, if so how about adding a new field and name it F1.

You indicate deleting the columns to the right of your last populated column in Excel, did you select ALL the coulumns to the right then to delete use Edit>Delete? There might be a cell with a formula still hiding, even the odd space might be the cause.

 

[was1]

I did select all the blank columns to the right. The macro worked for the very first import. I will be importing the file weekly. When I tried to import again, it asked for F1 field. I added F1 then it would keep asking for the next..F2 etc. I'm at F17 and its saying to add F18.

Any other suggestions?

thanks!