How to import into 2 tables at the same time?

[BlueStarBrite]

Lets say I have an Excel file that has SSN, Name, and DOB. And I have 2 tables. Table A & Table B. How do I import the SSN into Table A and at the same time import SSN, Name, and DOB into Table B? Is this even possible?

Thanks in advance

 

[Atomic Shrimp]

Easiest way would probably be to import it into table A, then run an append query to copy it into table B (or if there was already data in each of those, import it into a temporary table, then run two append queries, to get it into A and B...

...BUT...

It's generally not a good idea to have the same data in two different places - because it's unnecessary (you can just look it up from the other place, when you need it) and it's easy for the records in each of the copies to get out of sync or otherwise mismatched with each other.

What are you trying to achieve, that requires it to be that way?