custom warning message for data import

L

Laoballer

I'm creating an access program that will import a lot of tab delimited
text files. The table these files are being imported into has rules
so if I have a bad field in one of my file that record won't get
imported into the table. What I would like to do is be able to
display a msgbox with a message telling the user that the file being
imported won't import every record and that there's some fields with
bad data along with that file name. Is this possible?

I'm using DoCmd.TransferText acImportDelim

for the importing.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error trapping import error 8
Import text data 1
Import files into access 1
Docmd.Transfertext 'Autocorrect' error 2
import problem 1
Importing Excel Data - Error Message 3
File Location Prompt 3
Access 2003 Import Specs 1

Top