Search results

I am building a data consolidation tool in access. There are multiple Excel files from different vendors, each vendor has different format and for some years data the format keeps changing for the same vendor. I worked on a single vendor and created a unique field list for that particular...

I am uploading multiple Excel files through transfer sheet into Access table. After each upload of files, multiple queries are triggered to get the final data from the input file. Each file contains records on an average of 100,000 to 1,50,000. So since I upload all the files by looping files...

I am running the below query on around 100,000 records but it is taking ages, do not know why. UPDATE [tmpMaster] INNER JOIN iMaster ON [tmpMaster].[Name1] like "*" & iMaster.mName & "*" SET [tmpMaster].[iCode] = [iMaster].[iCode];