I'm trying to import certain data from excel files. There are very few things static between workbooks. The information I want is on the second sheet, but the names of those sheets might change. The headers for the information also tend to be the same but, they may be in different locations workbook to workbook. B10 in one B13 on another C11 on another etc. Unfortunately I have no control over the format of these workbooks as they are sent from other locations.
How would I use access to prompt the user to select files, then have access go through each file, locate <word 1> import cells below <word1> until it locates a blank cell into an access table? I would then want to reuse this process to locate other words and do the same as they are rows of records but I only need like 4 out of maybe 15 or more columns.
Each cell under <word1> would have corresponding cells under <word2> - <word4>
Any help would be greatly appreciated.
How would I use access to prompt the user to select files, then have access go through each file, locate <word 1> import cells below <word1> until it locates a blank cell into an access table? I would then want to reuse this process to locate other words and do the same as they are rows of records but I only need like 4 out of maybe 15 or more columns.
Each cell under <word1> would have corresponding cells under <word2> - <word4>
Any help would be greatly appreciated.
