Hi Eec,

Try one of the following:

1) Create an empty table in Access that has the same field names as your
Excel sheet. Where Excel has large text filds, the Access table should
have memo rields. Then import the Excel data into the Access table.

2) Rearrange the rows in the Excel data (or add a dummy first row of
data) so that every column that may include a cell containing more than
255 characters does have more than 255 characters in that first row (the
idea is to force these columns to be interpreted as Memo rather than
Text).

3) The methods discussed at
http://www.dicks-blog.com/excel/2004/06/external_data_m.html

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Thanks. The dummy row did the trick, and made what seemed an impossible
project feasible.