G
Guest
I've found some good things on the discussion board but I can't get exactly
what I want. I have a table that is being exported to a .txt file. One of
the fields in the .txt file must have leading zeroes to make it 10 digits
long. I have the field in the table as a Number field and have included the
leading zeroes, but when I export to the text file the leading zeroes are
dropped. Here is my code:
Function Table_to_Text()
DoCmd.TransferText acExportDelim, , _
"Text1", _
"C:\Text_File_1.txt", _
False
End Function
When I changed the field type to Text, it removed the leading zeroes,
probably because the original query that builds the Text1 table uses a number
field.
Thanks for your help in advance.
what I want. I have a table that is being exported to a .txt file. One of
the fields in the .txt file must have leading zeroes to make it 10 digits
long. I have the field in the table as a Number field and have included the
leading zeroes, but when I export to the text file the leading zeroes are
dropped. Here is my code:
Function Table_to_Text()
DoCmd.TransferText acExportDelim, , _
"Text1", _
"C:\Text_File_1.txt", _
False
End Function
When I changed the field type to Text, it removed the leading zeroes,
probably because the original query that builds the Text1 table uses a number
field.
Thanks for your help in advance.