Losing data importing from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Larry - 30 Aug 2004 13:06 GMT

I have a column in a spreadsheet that is used for
comments. When I import this spreadsheet I lose part of
the text. Has anyone experienced this also? What am I
doing wrong and what can I do to correct this?

Thank you.
Larry

Reply to this Message

Ken Snell [MVP] - 30 Aug 2004 13:56 GMT

"Import" meaning manually importing via File | Get External Data ... |
Import ?

That method uses old EXCEL format (95), which truncates text strings longer
than 255 characters. Use TransferSpreadsheet method in a macro or in VBA
code to import your spreadsheet's data -- that method allows you to specify
a newer version of EXCEL that will not truncate.

Signature

Ken Snell
<MS ACCESS MVP>

> I have a column in a spreadsheet that is used for
> comments. When I import this spreadsheet I lose part of
[quoted text clipped - 3 lines]
> Thank you.
> Larry

Reply to this Message

Larry - 30 Aug 2004 14:57 GMT

It works.
Thank you

>-----Original Message-----
>"Import" meaning manually importing via File | Get External Data ... |
[quoted text clipped - 14 lines]
>
>.

Reply to this Message