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