TransferText ... with the question

P

Patrice

Hi,

I have that command in a sub

DoCmd.TransferText acImportDelim, "Meteo", "Meteo", strPath_Nom

If something bad append like trouble with primary key, I'll get a message
from Access like " 0 record was imported..." but is no error.number generated

How can I trap the Access message to be able to continu in my code like that

If NoBadLuckWithTransferText then
bolTransfer = True
else
bolTransfer = False
end if

Thank you

Patrice
 

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

TransfertText... with the question! 7
TransferText 0
Verify file exists before executing TransferText 2
Verify file exists before executing TransferText 2
custom warning message for data import 1
No error on docmd.transfertext when expected 1
Dealing with unparseable records 4
VBA code to loop append query fails 3

Top