Excel field truncated on import

C

Craig Webster

Hi,

I've been using 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.

Please advise

Thanks

Craig
 
L

Larry Daugherty

I'm unfamiliar with behavior and limitations of the TransferSpreadsheet
method but it sure sounds like something is counting characters on you.

Something to try:

In Excel save the target spreadsheet as .CSV. Get into Access and see if
you can import it into your table with all characters intact. If it works,
you can write code to automate the process. If not, I haven't got a clue.

HTH
 

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

Excel field truncated on import 0
import csv truncation 1
EXPORT QUery with memo field to excel, truncated data 2
Mail Merge with Excel and Word 2007 1
Make Table Query Truncating Memo Field at 255 Characters 1
Avoid truncation 2
Importing Excel Data Into MS Access Memo Field 1
Fields Truncated During Import 1

Top