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

Importing Data from Excel to Access

P: 9
Hi to All!!

I need to inmport a Data from Excel to Access but the tables in Access are defined with a primary Key [ID] that is formated as an auto number (I'm using a template that I found on Internet!!) and it is giving me an error when i try to import it to my database, I can't. Also there are other fields on the table that are formatted to make a link to a list on the lookup properties than when i try to make the process, it deletes all the data on the field. Can you shed some light into this situation PLEASE!~!!!! thanks!!!!
Jan 5 '12 #1
Share this Question
Share on Google+
3 Replies

P: 332
Can you be more specific as to what error you are getting?
Assuming your import procedure does not try to force values in the primary key field, it should work fine. Linked lists may certainly be another source of problem. But again, more information is needed... Field types between source and destination table must also match.
Jan 5 '12 #2

P: 9
Hi Mariostg, I formatted all columns and fields exactly the same as in the Acces tables, the problem is that the ID field is formatted as autonumber, I don't know if i should try to leave that field blank and let the database insert the correspondent number in there. All fields that I have a combo box frmatted on the lookup properties tab are giving me problems. Suggestions?
Jan 5 '12 #3

P: 332
Yep, the autonumber field, you have to let MS Access handle that.
Your combobox fields probably have more than one column, and likely only one is visible but that is not the problem. The problem is which of these columns is the "bound" one. Whatever data type/value is in that bound column must be in the source table.
Jan 5 '12 #4

Post your reply

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