A
Andy Roberts
I want to import data regularly (the import format will always be the same)
and there are 2 things I wish to do as part of the process:-
First I want to hit an "Import button" on a form which then displays the
standard browse dialogue to allow the user to select the file.
Secondly I want the system to display a message of confirmation with the
number of records imported displayed in the message.
I have got it to work using an import specification (on the click event of
the command button) :
DoCmd.TransferText acImportFixed, "importcoords", "tblSecCoords",
"C:\import.txt", False
which works fine except for the two issues raised above. Can anyone help?
Andy
and there are 2 things I wish to do as part of the process:-
First I want to hit an "Import button" on a form which then displays the
standard browse dialogue to allow the user to select the file.
Secondly I want the system to display a message of confirmation with the
number of records imported displayed in the message.
I have got it to work using an import specification (on the click event of
the command button) :
DoCmd.TransferText acImportFixed, "importcoords", "tblSecCoords",
"C:\import.txt", False
which works fine except for the two issues raised above. Can anyone help?
Andy