Truncated when exported to excel (1 Viewer)

M

memaxt

Registered User.

Local time

Today, 08:50

Joined

Mar 12, 2013

Messages

62

• Sep 5, 2014

• #1

Hi all,

I'm trying to export my table using the following code:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "incidents", "c:\Incidents.xls", True

But unfortunatly I get truncated errors upon export via the vba above. is it not possible to export memo fields to excel via vba?

any ideas?

 

V

vbaInet

AWF VIP

Local time

Today, 16:50

Joined

Jan 22, 2010

Messages

26,374

• Sep 5, 2014

• #2

The following links will reveal all:

http://allenbrowne.com/ser-63.html
http://allenbrowne.com/bug-18.html

 

M

memaxt

Registered User.

Local time

Today, 08:50

Joined

Mar 12, 2013

Messages

62

• Sep 5, 2014

• #3

I could be wrong, but does this mean that it cant be done then?

 

V

vbaInet

AWF VIP

Local time

Today, 16:50

Joined

Jan 22, 2010

Messages

26,374

• Sep 5, 2014

• #4

Have you read the links?