Copy data from excel to access using a macro 1

[davidandrews8]

How can I create a macro which copies data from one sheet in a workbook to add to an exsisting table in access

 

[DarkSun]

Have you tried just using the Import wizard in Access.

File-Get External Data-Import

 

[davidandrews8]

An error occurs when tring to do this, which stops the data from being imported. Also the action needs to be automated, so that the data is imported by clicking on a command button, in either Excel, or Access (It is not important which).

 

[DarkSun]

That is quite a big thing to do. I could write it for you but I would need example data.

e.g DB Table information and excel sheet you want to import.

If you want I can write it on the weekend. My email address is dark_suns@lycos.com