Through VBA I am using a module which contains the apiGetOpenFileName lib comdlg32.dll to select multiple *.dat files, then VBA code to convert those files to *txt, and finally (using an import spec) import those files into my Access Table.
The process seams to work fine until I select over approx (146) .dat files. At this point I get no error messages but the remaining files are not imported and the corresponding *.txt files are not created.
Are there limitations to the comdlg32.dll? Any Ideas?
Thanks in advance for any help!
The process seams to work fine until I select over approx (146) .dat files. At this point I get no error messages but the remaining files are not imported and the corresponding *.txt files are not created.
Are there limitations to the comdlg32.dll? Any Ideas?
Thanks in advance for any help!