Import confirmation / status message box?

[Anika]

OK, so I figured out how to import my data and now I'd like to display a message box with either success or failure message. How would I be able to determine whether my import failed?

Sorry for the begginer types of questions, still learning.

- Code Kiddie

 

[HiTechCoach]

What code are you using to do your Import?

Depending on your VBA code, it may be possible to use error trapping or some other techniques. It will depend on how your are doing the import.

 

[Anika]

This is my code:

Private Sub Import_Sbod_Click()

Dim path As String
path = InputBox("Enter the full path to your text file. Example: C:\TestFile.txt", "File Location")
DoCmd.TransferText acImportDelim, "test", "Sbod", path
MsgBox "Import Complete", vbOKOnly, "Confirmation"

End Sub


If there is another method of import that allows for error checking, I am open to changing my code. Thank you.

 

[gemma-the-husky]

does that method import to a new table, or an existing one

either way, just count the number of items imported

dcount("*","mytable")

and report to the user.

if there were errors, i think you get an appropriate error table, which you could look for also