Transfer text command

[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........

 

[John Nurick]

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.

 

[Ken Snell [MVP]]

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?

 

[John Nurick]

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?

Good idea. Certainly worth trying.