Append certain Excel row data to Access table fields
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!