I
imbroto
Guest
Hello I need to create a button on a form to export 3 tables to Tab delimited text files. I don't want to export from access but from my main form all three tables in one button click. I am creating a code event in vba that looks something like this. I call this command three times but the files get written as quote delimited instead of tab delimited.I am also having problems with the second perameter "StandardOutput" if I take it out the files get written quote delimated
if it is kept in it reads an error at ruin time saying "the text file specification Standard output does not excist. What is the correct call for a tab delimited file and what is a schema file?
DoCmd.TransferText acExportDelim, "Standard Output", "Catalog", "C:\Txtfiles\Catalog.txt"
Thank You
Frank
if it is kept in it reads an error at ruin time saying "the text file specification Standard output does not excist. What is the correct call for a tab delimited file and what is a schema file?
DoCmd.TransferText acExportDelim, "Standard Output", "Catalog", "C:\Txtfiles\Catalog.txt"
Thank You
Frank
