Make Table Query Truncating Memo Field at 255 Characters

E

excelCPA

I have a lot of data in an Excel spreadsheet that I want to analyze
with Access. Many of the data fields are >255 characters. I
understand linked tables to Excel in Access will truncate all fields
at 255 characters, but imported tables will not truncate.

I successfully imported that data in to Access, the large fields are
not truncated, and set to 'Memo' type fields.

When I run a make table query against the imported table, the query
truncates the memo fields at 255 characters. The new table's
properties have the applicable fields set to 'Memo'.

How can I keep a make table query in Access from truncating memo
fields at 255?
 
K

Ken Snell

What is the SQL statement of the query that you're using as the make-table
query?
 

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

Top