Run-time error 3163

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Anyone have any ideas?

I'm not using any Memo fields and even taking my final query and making a
temp table with it and then using a basic query to make my .txt file still
gives me the error.
 
Back
Top