How do I import a xls table with autonumber pk to access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a xls table PK autonumber, name and city fields. I need to export that
table to a table (with same fields) in a related database in Acces. I used
the get external data option in access but failed.
I would really appreciated you help
 
How did it fail? Primary key constraint error? If so you are trying to put in
a number that already exists in the database.

What is your objective with the Excel data? Add all the data? Add only new
records? Modify existing records? Or some combination of all the above? What
you want to do will dictate how to do it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoNumbered PK, "Invalid Argument" At 20,847,689? 4
primary key - concatenated or autonumber? 6
Keeping autonumbering after going to SQL backend 6
Autonumber as Primary Key and Relationships 13
Concatinating one PK from one tbl & autonumber for a PK in a 2nd t 7
Questionnaires PK & Tables 5
Add autonumber to a large table? 0
append query to table with autonumber pk 2

Back
Top