Importing Text Data Using Code : Database Transfer « Access « VBA / Excel / Access / Word






Importing Text Data Using Code

 
Sub ImportText()
  DoCmd.TransferText _
    TransferType:=acImportDelim, _
    TableName:="Employees", _
    FileName:=CurrentProject.Path & "\Customer.Txt"
End Sub

 








Related examples in the same category

1.Using the TransferDatabase Method
2.transfer database acExport
3.Importing Spreadsheet Data Using Code
4.Export database
5.Import database
6.Exporting to a Database