468,740 Members | 2,018 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,740 developers. It's quick & easy.

Import Excel into Access 'Field6' issue

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?
Jan 19 '10 #1
2 2003
3,079 Expert 2GB
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.

Jan 19 '10 #2
2,321 Expert Mod 2GB
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.
Jan 19 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by John Hardy | last post: by
reply views Thread by jere7 | last post: by
4 posts views Thread by Earl Anderson | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
2 posts views Thread by xarzu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.