Linking Excel to Access Problem with Text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lex - 16 Aug 2004 02:17 GMT

I have linked to excel and am finding the text cells are truncated in Access.
The data type is memo.

Any help is greatly appreciated.

Reply to this Message

John Nurick - 16 Aug 2004 06:37 GMT

Hi Lex,

According to http://support.microsoft.com/?id=839785 that's the way it
is.

The official work-round is to import the data instead of linking, but
it's also possible to use Automation to get the individual cell values
direct from the worksheet.

>I have linked to excel and am finding the text cells are truncated in Access.
>The data type is memo.
>
>Any help is greatly appreciated.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message