PDA

View Full Version : Solved: Transferring data from Excel to Access macro



mbbx5va2
05-17-2013, 06:00 AM
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
05-17-2013, 06:42 AM
You might want to reply to my post, that you are moving this question to the Access Help Forum, (Access Help (http://www.vbaexpress.com/forum/forumdisplay.php?f=16),) 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
05-17-2013, 07:10 AM
Ok no problem