Importing excel data truncates my comments

[Kiron]

Hi

Am trying to import an Excel sheet to access table and i find the comments section being truncated.

Am using the
DoCmd.TransferSpreadsheet method.

I have checked the comments field of my table is memo/long text without the @ but still it truncates to 255 characters like a regular text field. Why?

I looked around for answer invain.
Am not using any query here so no question of "grouping" or "union all" arises. Its a simple importing of excel data.

Please advise what could i be doing wrong.
Thank u

 

[theDBguy]

Hi. There are a few discussions of this issue in the forum with varying results. Are you able to post a sample copy of the Excel file for testing?

 

[isladogs]

Probably because you have applied formatting to the memo field.
For a list of all possible causes see http://allenbrowne.com/ser-63.html

 

[Kiron]

Hi Isladogs,

Read the link provided and follow them. Still didn't work.
Am surprised this can be so complicated!

 

[isladogs]

In order for anyone to assist further we would need to have the Excel file you are importing together with the table from your database and the full code used