Is there a size limitation to a column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Add autonumber to a large table? 0
Printing SQL query results in a list of columns, instead of one long column 1
Column Limitation? 1
removing #error for calculation results when there is a null value 6
Limit to Expression Size in Query ? 11
number of columns in a query 3
Count in a query 2

Back
Top