Excel field truncated on import...help?

[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

 

[Jamie Collins]

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

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.

--

 

[Steve Newton]

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,

Many thanks. This appears to be the kind of explanation I'm looking
for.

Steve