Macro for Import of data

[CB100]

Good morning, I have a macro to import a table from Excel and would like
expand that macro to import the same sales table into 2 tables. One table is
just for the regular import, all data, and one is to have the primary key
set to the customer number so that only one entry comes in for that customer.
I am sure there is an easier way but don't know enough about macros and vba
to accomplish this.
Thank you

 

[Clifford Bass]

Hi,

How about just repeating the same step(s), only into the second table?
Or create an append query that gets its information from the first table and
appends it to the second? If you use the second option, you will need to
figure out how to identify the row you want to place into the second table.

Clifford Bass