Excel field truncated on import...help?

  • Thread starter Thread starter Steve Newton
  • Start date Start date
S

Steve Newton

Hi.

I am using Access 2000 to import data from an Excel spreadsheet with
the Get External Data command.

A couple of the columns in the Excel spreadsheet contain more than 255
characters. Thus I have prepared the Access table in advance,
designating the relevant fields as Memo fields.

I have successfully used this feature to avoid the truncation that
might otherwise occur. However, a friend of mine who is using Access
97 to retrieve the same Excel data (and who has prepared the Access 97
table in advance, declaring Memo fields where relevant) continues to
find that the fields are truncated on import.

I did a little searching in the MS KnowledgeBase and on the web in
general, but I can't find the definitive answer for solving this
problem (if there IS one).

TIA

Steve
 
Steve Newton wrote ...
A couple of the columns in the Excel spreadsheet contain more than 255
characters. Thus I have prepared the Access table in advance,
designating the relevant fields as Memo fields.

I have successfully used this feature to avoid the truncation that
might otherwise occur. However, a friend of mine who is using Access
97 to retrieve the same Excel data (and who has prepared the Access 97
table in advance, declaring Memo fields where relevant) continues to
find that the fields are truncated on import.

I did a little searching in the MS KnowledgeBase and on the web in
general, but I can't find the definitive answer for solving this
problem (if there IS one).
Click to expand...

Nor definitive answer but hopefully you will find the advise here useful:

http://www.dicks-blog.com/excel/2004/06/external_data_m.html

Jamie.

--
 
Back
Top