Search results

Hello everyone! I am using the below code to link my Access db to excel and name the linked excel as "Tabelle1". After using the data from excel I want to remove this link and make free Access from excel. How should I do it through VBA ? Thank you for help DoCmd.TransferSpreadsheet acLink...

Hi. I have attached file with linked excel file. Now I want to use Dlookup() function in the linked excel file to search if the data (available on field1 of tabelle1 in my access db--- see file attached) is availble in the Feld1( excel linked to access db). After checking it is availabe then...

Ok thanks now I can link access db to the chosen excel file. Now I have to move further and have to use Dlookup function() in the linked excel file to search if the data (available on field1 of table1 in my access db--- see file attached) is availble in the column 2 or now Field 2( as now excel...

Anyone? Please☹

The above code just opens the dialog box and when I select it to go in the excel data I am getting an error 1003 on the second last line of my code (I think it is not getting my excel sheet name object) . And I also don't how to write the Dlookup function further

Hi. Different means every time I will be using different excel file to look up for a similar value which is available in my access dB table. That's why I want to write a vba which opens a dialog box and ask me to select the excel file that have the value details as I shown in the picture. The...

My excel file will change every time with different name so I want to write a code so that I every time I select the right file. I don't want to use manuell linking with excel file. I think I can only use dlookup when I have data available in access dB I don't know with this function I can...

Hi. I have attached the files as an example like in access db I have a table and there are 6 codes written in there and I have to look in a excel file in Column B if these codes are available there and then copy the corresponding right cell i.e. from column C and paste it in the right of the...

Hello everyone! Iam new to Access programing. I want to write a vba code in Access that looks if field data (available in access user interface) is also available in the excel spreedsheet and then copy the data available on the next right cell of exel to table in the MS Access. Anyone can...