Append certain Excel row data to Access table fields (1 Viewer)

Aspire

Registered User.
Local time
Today, 04:31
Joined
Apr 25, 2012
Messages
12
Hi there!

I hope you can help. I am not having much luck researching this.
I am looking to:

1) have an Access user choose a row number that corresponds to a row on an Excel spreadsheet. I have a little pop-up form that asks the user to choose a row and a button to launch the vba.
2) transfer data from several columns in that row and append it to a new row of an existing Access table.

For instance, if they choose row 19, information would transfer from Excel's row 19 column D to [tblCustomers].[Name]; from column E to [tblCustomers].[Address], etc.

I truly appreciate your help and insight!
 

Users who are viewing this thread

Top Bottom