Importing From Excel to Access Table - Microsoft Access Forum

8 minutes ago: Please note that the webserver will soon get its weekly reboot at 4:00 am Eastern Time. You may continue to use the site as normal, but you will be logged off at that time. You should be able to log right back on immediately, however. If you are in the process of placing an order, please make sure to complete it as quickly as possible, or come back after the reboot. Thank you. Sorry for any inconvenience. Dismiss

Free Lessons
Courses
Seminars

TechHelp
Fast Tips
Templates

Topic Index
Forum
ABCD

Home Courses TechHelp Help Contact Merch Join Order Logon Forums


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Importing From Excel to Access Table

Jean McGowan

15 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 15 months ago
Whats the purpose of the spreadsheet?

	Jean McGowan OP @Reply 15 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 15 months ago
Import Excel Import Access Automated Import Excel Import Cleanup Excel Import Cleanup 2

	Jean McGowan OP @Reply 15 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 15 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