Transfer data from Excel to Access
Can anyone help me create some code that will do the following?
I need to upload/transfer specific cells in Excel to an existing table
in Access. These cells are specific to records in my table. For
example, "C1" needs to be uploaded to "tblPrice". The field it needs to
be put in is "Surcharge". The record is "10". How do I write the code
to make this happen? Any help would be greatly appreciated. I'm not the
familiar with writing this type of code.
|