Export to a Comma Separated File : Access Import Export « Access « VBA / Excel / Access / Word






Export to a Comma Separated File

 
Sub export()
     DoCmd.TransferText acExportDelim, "CompanyDelimited", "tblCompany", _
           "C:\Delimited.txt", True
     MsgBox "Company details exported"
End Sub

 








Related examples in the same category

1.Export to a Fixed Width File
2.Importing from a Fixed Width File
3.Importing from a Comma Separated File
4.Export table to asp page
5.Export table as html page
6.Export table as htx file
7.Export table as rtf file
8.Export table as txt file
9.Export table as xls file
10.Transfer database through ODBC