I import a text file into my Access 2010 database. It takes a few minutes and although the hourglass displays, it will be nice to display a progress value in a textbox on the import form while importing.
If I imported per individual records, I could increment some value between records to display the progress. However I use DoCmd.TransferText like in
DoCmd.TransferText acImportDelim, "CFE", CFEtblToImportTo, "C:\MMI\txtFiles Originals\" & CFEFileToImport & ".txt", True
I can't see how to put an incrementer in there.
I know that it takes about two minutes to import and would like to display on my form how much time is left or something like that.
Is there a way?