Importing Excel Data Into MS Access Memo Field

[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!

 

[Ken Snell \(MVP\)]

See this article:

Avoid DataType Mismatch Errors when Importing Data from an EXCEL File or
when Linking to an EXCEL File
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#DataTypeErr

 

[kurircek]

You should try importing to access from excel following this steps:
1. prepare blank database with correct MEMO field in access
2. from access import excel into access via append option
3. produce "return" chr(32) charatcter in word (enable Show paragrphs marks...)
4. copy it
5. open find replace dialog box
6. find "return" character, replace blank
7. remove all via find-replace function
For me it works, memo fields are not truncated! They were not before, it only looked like.