Access 2002 truncates text when linking to Excel 2002

G

Guest

I want to link into an Excel 2002 spreadsheet worksheet into an Access 2002
table. Some worksheet cells contain long text strings (400+ characters, in
some cases), but Access truncates the field length (apparently at 255
characters) when I link the Excel worksheet as an Access table. How can I get
all the characters in the worksheet into the linked table? I've tried
File/Get External Data/Link ... got truncated. I've tried
Macro/New/TransferSpreadsheet/Link/Microsoft Excel
8-10/worksheet/path&filename/Yes/(no range) ... got trucated. What's the
solution?
 
J

John Nurick

Alas, this is normal behaviour. See
http://support.microsoft.com/?id=839785

If you're inclined to experiment, search a newsgroup archive (e.g.
groups.google.com) for something like
importmixedtypes excel access link
You'll find some information on tweaking registry settings - but as far
as I can tell there's no tweak that says "link as memo rather than
text".
 

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

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing Excel Data Into MS Access Memo Field 2
EXPORT QUery with memo field to excel, truncated data 2
linking xls worksheet to Access without truncating text in xls cel 1
255 Character Limit for Linked Excel data 1
Access 2002 OutPutTo to Excel 2002 truncates memo 3
Import to Excel resulting in hash marks and chinese looking chars? 5
truncated data from linked excel worksheet? 2

Top