Solved: Transferring data from Excel to Access macro

[mbbx5va2]

Hi

If I had a A1:C3 table in an excel worksheet called "Client details" with column headings "ClientID" = A1, "Firstname" = B1, "Lastname" = C3

Then if I filled in the table with data i.e in cells (A2:C3) and then wanted to create a button where if I clicked then it would transfer the data in the table including the column headings into an Access database, what code would I assign to the button?

Regards

[SamT]

You might want to reply to my post, that you are moving this question to the Access Help Forum, (Access Help,) and use the Tread Tools at the top of this thread to mark this thread "Solved."

Just Copy and Paste your original question into a new post in the Access forum.

[mbbx5va2]

Ok no problem