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

Similar Threads

Query field size quandry 2
disctinct query memo field 3
Totals query and Memo field 3
appending more than 255 characters into a Memo field 7
SQL Strings Truncating at 255 Characters ? Why? 1
Export to excel has character limit 3
Append to SQL Server 3
How can I convert text field to memo field in a query 10

Top