Losing data importing from Excel

  • Thread starter Thread starter Larry
  • Start date Start date
L

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




.
Click to expand...
 
Back
Top