Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DoCmd.TransferText
Message
De
11/07/2013 21:37:14
 
 
À
Tous
Information générale
Forum:
Visual Basic
Catégorie:
Access
Titre:
DoCmd.TransferText
Divers
Thread ID:
01578247
Message ID:
01578247
Vues:
34
When I get to the last line of the Sub, I get the following error: Field F1 does not exist in the destination table 'do_not_call.'

This has really got me stumped. The import file is comma delimeted and looks like: 917,5551234. Any suggestions would be appreciated.
Private Sub ImportFile(strFullFile As String)
    Application.SetOption "Confirm Action Queries", 0
    Application.SetOption "Confirm Document Deletions", 0
    Application.SetOption "Confirm Record Changes", 0
    DoCmd.RunSQL "Delete * from do_not_call'"
    DoCmd.TransferText acImportDelim, "", "Do_Not_Call", strFullFile, False
    
End Sub
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform