Hi all,
I need to create a vba code to import 1 specific cell from an excel spreadsheet containing some currency data for each of my registered customers.
The excel spreadsheet contain more than 60 columns so I am not willing to upload the whole spreadsheet.
Having in mind that in the excel spreadsheet the column A have the customer ID and column W have the currency I need to upload, my idea was to loop through my existent customers in the database and using its ID number search for it in the excel spreadsheet column A and upload the data in column W when customerID matches.
My question is: how can I, from access, create a loop through the cells in excel to compare with my database information? Or how can I upload only my columns A and W without knowing exactly the number of lines that it contains?
I hope it makes sense,
Thanks for your help
I need to create a vba code to import 1 specific cell from an excel spreadsheet containing some currency data for each of my registered customers.
The excel spreadsheet contain more than 60 columns so I am not willing to upload the whole spreadsheet.
Having in mind that in the excel spreadsheet the column A have the customer ID and column W have the currency I need to upload, my idea was to loop through my existent customers in the database and using its ID number search for it in the excel spreadsheet column A and upload the data in column W when customerID matches.
My question is: how can I, from access, create a loop through the cells in excel to compare with my database information? Or how can I upload only my columns A and W without knowing exactly the number of lines that it contains?
I hope it makes sense,
Thanks for your help