Place txtField from Excel File1 into a field in Excel File 2 using a VLookup function
I have 1/. An Access dbase with tblBookings linked to 2/. An Excel File "AccessBookings" Sheet(AccessBookings) which consists of Rows from Access dBase 1/. I have 3/. Excel File "Quote" with a sheet (FltSheet).
In 2/. the first column contains the integerID from the Access dBase and another column contains a txtField (DestText) that will be generated in VBA from 3/.Excel File "Quote".(SourceText)
I would like to take the integerID generated in 3/."Quote" and use it to locate and enter 3/. SourceText in the 2/. DestText field. (vlookup ?)
With that in place the Access dBase can be updated to reflect the addition of the DestText
The Excel File 3/. starts as an .xltm file which changes to a RandomFile.xlsx .
I was advised that DAO may be the way to go but that is beyon me at present (Much as I'd like to try). Hope there's a Fundi out there who can assist. Thanks