Importing From Excel to Access Table - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Importing From Excel to Access Table

Jean McGowan

12 months ago

I have a table tblservicelineitem with linenumber as PK and autonumber. At times we like to use a import of a spreadsheet that duplicates the table. We input the spreadsheets values for everything but Autonumber. What do I need to do so that it will append the table with an autonumber so I can not voliate the null autonumber? We can't see the number in the table so I can't just input them. Willing to go into more detail if needed.

	Bill Carver @Reply 12 months ago
Whats the purpose of the spreadsheet?

	Jean McGowan OP @Reply 12 months ago
We have so many line items that we can cut and paste into a spread sheet. I don't want to have our people type them in one at a time. So the import tool take the spreadsheet edited and imports it directly into the table. Our people add a contract number and date.... We can have an order with 10000 lines on a weekly basis.

	Alex Hedley @Reply 12 months ago
Import Excel Import Access Automated Import Excel Import Cleanup Excel Import Cleanup 2

	Jean McGowan OP @Reply 12 months ago
thank you I am good at importing but I am having the problem with the PK numbering? Which one of these addresses that issue

	Alex Hedley @Reply 12 months ago
It's an AutoNumber it should be added automatically. What method are you using to import currently?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View