Run-time error 3163



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

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", _

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads