TransferText

P

Patrice

Hi,

I have that command in a Sub

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

If something wrong with the importation (like trouble with primary key) I'll
have a msgbox from Access like "0 record was imported.... " but no error
number is generated. How can I trap the Access message?

I'd like to continu with something like that

If NoImportationTrouble then
ImportMeteo = True
else
ImportMeteo = 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

TransferText ... with the question 0
TransfertText... with the question! 7
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
transfertext delimited 1
Verify file exists before executing TransferText 2
Verify file exists before executing TransferText 2
TransferText acImportDelim takes abnormal amount of time. 0
Importing Data Error Checking 1

Top