G
Guest
Sometimes this stuff just gets annoying. I have my data displaying perfectly
in my query yet when I export it to a .txt file I am getting this error.
-----------------------------------
Run-time error '3163'
The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data.
-----------------------------------
I can't tell it to ignore the error because then it won't run my
docmd.transfertext line.
Now I am running a complicated series of queries and combining them in a
Union query in order to get the data formatted in the way that the other
program wants it.
For instance:
-I have a single header line (for lack of a better word) with all the
specific fields that it wants.
-then I have multiple data lines after each header line
-Both have the same number of fields
-However data in field 5 (header) may be text while the other (data) may be
integer
But like I said, the final query itself is working/displaying perfectly yet
when I try to make the txt file I am getting the error.
My transfertext line is thus:
DoCmd.TransferText acExportDelim, "PO Export", "qry Export PO - Ub", _
"T:\_Printouts\Access\POImportTest.txt"
I don't think its the line above as it works fine with a simplier query.
Anyone have any suggesstions to get rid of the error?
in my query yet when I export it to a .txt file I am getting this error.
-----------------------------------
Run-time error '3163'
The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data.
-----------------------------------
I can't tell it to ignore the error because then it won't run my
docmd.transfertext line.
Now I am running a complicated series of queries and combining them in a
Union query in order to get the data formatted in the way that the other
program wants it.
For instance:
-I have a single header line (for lack of a better word) with all the
specific fields that it wants.
-then I have multiple data lines after each header line
-Both have the same number of fields
-However data in field 5 (header) may be text while the other (data) may be
integer
But like I said, the final query itself is working/displaying perfectly yet
when I try to make the txt file I am getting the error.
My transfertext line is thus:
DoCmd.TransferText acExportDelim, "PO Export", "qry Export PO - Ub", _
"T:\_Printouts\Access\POImportTest.txt"
I don't think its the line above as it works fine with a simplier query.
Anyone have any suggesstions to get rid of the error?