Excel field truncated on import

  • Thread starter Thread starter Craig Webster
  • Start date Start date
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
 
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
 
Any solutions....?

Does anyone have a solution to this problem. I have a similar situation, even though the data type is set to memo the text is truncated while importing from an Excel file.


Thanks.....
 
Craig, did you find a solution to Import problem? I am struggling with the same issue and nothing on the Internet. Please help me out too if you found a solution.

Thanks....
 
Back
Top