Excel field truncated on import

C

Craig

Hi,

I've been using (trying to use) the TransferSpreadsheet
method to automate importing data from Excel tables to an
Access table. The problem I'm having is that Excel fields
with more than 255 characters are being truncated even
though they're being imported into memo fields in my
Access table.

I've tried breaking up the fields that were too long with
the len function in Excel but still got errors. I tried
to converting the excel files to txt and fields are still
truncated.


Please advise

Thanks

Craig
 

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

import csv truncation 1
Excel field truncated on import 1
Mail Merge with Excel and Word 2007 1
EXPORT QUery with memo field to excel, truncated data 2
Avoid truncation 2
oracle fields exceed 255 3
Make Table Query Truncating Memo Field at 255 Characters 1
transfer to excel 1

Top