By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,270 Members | 1,582 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,270 IT Pros & Developers. It's quick & easy.

Import Excel into Access 'Field6' issue

P: 1
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
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,072
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

Expert Mod 100+
P: 2,321
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.