Importing Excel columns to different tables

[ORN]

I have an Access db that I need to import a lot of data from Excel on a regular basis but need the data to go to different fields in different tables. Is there an easy way to do this? And hopefully I'd like to automate the process as much as possible.

I'm not new to Access but am still working on doing more complex tasks.

Thanks in advance,
ORN

 

[BLeslie88]

Sure....

Well when you import, you can select to skip columns while creating import specifications... So you could create many specifications for one file always selecting the columns you need for each table. This is one approach. Hope it helps...

Regards,