Is there a size limitation to a column?

J

JE

I have a pass-thru query. The query is accessing another system to pull in
the results. I have found that all the results are not displayed in the
column. We are researching with the other vendor but wanted to ask if the
column has a maximum number of characters allowed? Thank youu.
 
J

Jerry Whittle

An Access text field can have a maximum of 255 characters. Something like an
Oracle Varchar(2) field can have 4,000 characters. Therefore if you are
trying to pull in Oracle data, it might be like putting 10 gallons into a 2
gallon bucket.

You could try putting the data into a Memo field which can hold 65,000
characters.
 
J

JE

I appreciate this suggestion. Thank you.

Can you direct me to guidance on revising the query such that the data is in
a Memo field? Many thanks.
 
Top