Copy data from Office Clipboard to Various already created tables in ms Access

[fadihs]

Greetings all
I have an excel file which has 5 sheets. I want each of these sheets to be copied to 5 different tables in ms Access. Tables are already Built and linked with each other. I have to repeat this process a thousand times. So i want to automate this process of copy and pasting.

or there can be another option. id there any way to copy data from Office Clipboard to various already built tables in MS Access.

Thanks in advance

 

[alansidman]

Why not use the Access Wizard to import the data directly into each of the required tables.