ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Transfer data from Excel to Access (https://www.excelbanter.com/excel-programming/357107-transfer-data-excel-access.html)

SecretSquirrel

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.



All times are GMT +1. The time now is 06:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com