Importing from excel to access, multiple tables

[giddyup43]

Hi.
I receive an excel file every day that I would like to append to my tables in access. It needs to be split into a few tables:
Orders, Transactions and Customers.
I couldn't do it via append query because of the primary keys. I have Order Numbers set up to be the Primary Key in the Orders table, I have transaction number set up to be the primary key in the transaction table and customer email to be the primary key in the customers table.
Access will not let me import my columns when these primary keys are set up.

Is there any way to do it?
Please let me know.
Thanks!

 

[xenou]

Is the problem that you have duplicate keys you are trying to append? If so, how do you want to deal with the duplicates?

 

[Tesla]

Let me suggest using Excel Automation from MSAccess. Put Excel in a specific folder with a sub-folder of "imported"
With automaiton, Access can open the Excel, import it, then move the Excel to the sub-folder "imported"
Typically, I import the Excel into a Staging Table. A local Access table that just has an autocounter and basically imports the data.
Once the data is in the Local Table - it can be processed as needed.

As xenou mentioned, does your data have a column or other indicator that makes Orders or Transactions different?
For example: are orders on one tab of an Excel workbook and transactions on a different tab?
A primary key can consist of two fields if needed.
It will depend on your plan to deal with the ID for each category (Orders, Transactions, ... other).

If you are really new to Access, take a look at Sample Databases - Access World Forums
There are around 400 sample databases that are free to download. A couple are my own. A recent addition is importing Invoices might give you some ideas.
Just to give you an idea, here is just one example: Import Multiple Spreadsheets - Access World Forums
This example shows how to use the file dialog picker to select multiple Excel files for importing into new Access tables. This can of course be expanded upon to suit different needs, but the base idea is probably here.

Once you get a working example, ask questions about modification to suit your specific need.