Copy and Paste Excel Table to Access

[maxscott]

Hi

I have a reasonably large excel table which I can easily select and copy and then paste directly into Access - it create a new table using the column headings as the field names. This works very efficiently.

But how can I do that with VBA?

I have tried various ways such as looping through each row on the excel table, creating a new record in the access table and then updating each field. I have also tried transfer spreadhseet in Access. And I've tried loading the excel table into an array and then updating the access table from each row and column. None of these are as efficient as the simple copy and paste. But I can't see how to do that with VBA.

Can it be done?

Apologies if I should post this to an Access forum?

Thanks

Max

[alansidman]

Have you considered linking your Excel Table to Access?

https://www.youtube.com/watch?v=oiLMfKyavEU

[maxscott]

Works a treat. Hadn't thought of that and after a little playing around with it seems to be just what I need.

Thank you

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.