VBA/Excel/Access/Word/Access/Text Transfer

acImportDelim

   <source lang="vb">

Private Sub cmdImportDelimited_Click()

   DoCmd.TransferText acImportDelim, "CompanyDelimited", "tblCompanyDelimited", "C:\Delimited.txt", True

End Sub

</source>
   
  

acImportFixed

   <source lang="vb">

Private Sub cmdImportFixed_Click()

   DoCmd.TransferText acImportFixed, "CompanyFixed", "tblCompanyFixed", "C:\CompanyFixed.txt", True

End Sub

</source>