Losing data importing from Excel

[Larry]

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

 

[Ken Snell [MVP]]

"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.

 

[Larry]

It works.
Thank you

-----Original Message-----
"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.

--

Ken Snell
<MS ACCESS MVP>




.