Transfer text command

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to display the elapsed time while the macro is executing the
the followign command:

DoCmd.TransferText acImportDelim, "Test Data Specification", "Test_Data",
Location, False

The file I'm importing is very large and can take up to 10 minutes to
import.

I would like to show the elapsed time (and continually update it) on the
Status Bar. Is this possible. Any suggestions would be appreciated.
Thanks for the help........
 
I think the answer is no. If you write VBA code to import the text file
line by line, you can update the status bar as you go.
 
I haven't tried it, but would opening a form with Timer event procedure that
updates elapsed time on the form, then do the TransferSpreadsheet action,
work?
 
I haven't tried it, but would opening a form with Timer event procedure that
updates elapsed time on the form, then do the TransferSpreadsheet action,
work?
Click to expand...

Good idea. Certainly worth trying.
 
Back
Top