Importing Excel Data Into MS Access Memo Field

M

Mike S. S.

I have a column of text data in Excel whose cells run into thousands of
characters. When I try to import it, Access truncates the text, even if I
save the Excel file as delimited text and import. I know there is a way to
tell Access a minimum char size even for a memo field but I can't find where
to do this in the process. So what is the problem with Importing, whether an
XLS or a TxT file? I also noticed when linking the Excel file that the
column with the large text values are also truncated, but I thought that
might have more to do wtih linking rather than importing.

HELP!
 

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

Autonumber field in Excel that behaves the same as Access 0
problems importing a Paradox file into Access 2003 4
Merging from an Excel file with graphics 1
EXPORT QUery with memo field to excel, truncated data 2
Formatting Text from Excel 1
importing excel 1
Truncation of memo fields using DoCmd.TransferText acImportDelim, 1
Importing hyperlinks 2

Top