Import Excel into Access 'Field6' issue

[OpusMagnum]

I'm trying to import an Excel spreadsheet and append a current table within the Database.

I have have all the Access column names within the spreadsheet.
Access wants to import a blank column and names it 'Field6'.

I've tried to keep it from importing, but for some reason it wants to import that blank columns.

Any suggestions?

[nico5038]

Looks to me there's something (doesn't have to be visible) in that row.
You can suppress the field using the wizard and store the "script" to reuse the next time. Storing can be done pressing the [Advanced] button bottom left.

Nic;o)

[TheSmileyCoder]

Excel cells hold the value Null as default. If you type something into a excel cell and then delete one might think it would return to null, but instead its now a 0-length string. (At least thats the conclusion I have arrived at)

If its a one time thing, just import the sheet to another table, then run an append query afterwards.

I had a situation where I would often import the same columns from excel sheets, but the user had a nasty habit of using the "extra/blank" columns for his own notes and such. I created some code to (invisible to user) copy the excel sheet to a new file, open it, delete Columns E-ZZ, import it, then delete the copy.

You could try a similar approach, if its something you need to do often.