I have a large 49,000-record table from Excel I would like to import to
Access(2002 but the same happens also with XP 2003), mostly text and
memo fields. When I use the import wizard, fields are correctly
recognized, but then, when checking the resulting table I found that
most large fields (from 400 chars to 6000 chars) were truncated
somewhere after approx 390 chars (so larger than the 255 max chars for
text fields). This is not dependent on the type of characters of
punctuation and may happen anywhere in a sentence. Any idea why this
happens?
thanks,
Elena
PS - as I am no programmer, pls use simple words when answering
--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG