linking xls worksheet to Access without truncating text in xls cel


C

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
 
Ad

Advertisements

K

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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top