asked on
Exporting Access table to tab delimited text file
Is there a way to export an Access table to a tab delimited text file using vba?
I have the following line of code which creates the text file but it is comma delimited.
DoCmd.TransferText acExportDelim, , "PNLFile", "c:\temp\PNLFile.txt", False
I have the following line of code which creates the text file but it is comma delimited.
DoCmd.TransferText acExportDelim, , "PNLFile", "c:\temp\PNLFile.txt", False
Microsoft Access
Last Comment
dsoderstrom
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you both