Importing excel data truncates my comments (1 Viewer)

K

Kiron

New member

Local time

Today, 04:04

Joined

Jul 23, 2019

Messages

9

• Aug 12, 2019

• #1

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

I’m here to help

Staff member

Local time

Today, 04:04

Joined

Oct 29, 2018

Messages

21,454

• Aug 12, 2019

• #2

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

MVP / VIP

Local time

Today, 12:04

Joined

Jan 14, 2017

Messages

18,209

• Aug 12, 2019

• #3

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

 

K

Kiron

New member

Local time

Today, 04:04

Joined

Jul 23, 2019

Messages

9

• Aug 13, 2019

• #4

Hi Isladogs,

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

 

isladogs

MVP / VIP

Local time

Today, 12:04

Joined

Jan 14, 2017

Messages

18,209

• Aug 13, 2019

• #5

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