linking xls worksheet to Access without truncating text in xls cel

[CAPcoordinator]

Hello all-

I am wondering if anyone can tell me whether it's possible to prevent my
data from being truncated, when I link an Excel worksheet to my Access 2003
DB? If so, how? My data is not truncated when I Import the Excel sheet but I
would prefer to link rather than import if possible...

thank you much
-Chris

 

[Ken Snell \(MVP\)]

The error that you're seeing likely is because Jet (ACCESS) sees only "short
text" values in the first 8 - 25 rows of data in the EXCEL sheet, even
though you have longer text farther down the rows. What ACCESS and Jet are
doing is assuming that the "text" data actually are Text data type, not Memo
data type,.

One way to "fix" this problem is to insert a dummy row of data as the first
row, with a text string longer than 255 characters in the cell in that
column. That should let Jet (ACCESS) treat that column's values as memo and
not text.

It's possible to force Jet to scan all the rows and not guess the data type
based on just the first few rows. See this article for information about the
registry key (see TypeGuessRows and MaxScanRows information):
http://www.dicks-blog.com/archives/2004/06/03/external-data-mixed-data-types/