D
Dave Ruhl
After upgrading from Office 2002 to Office 2003, my code to export data from
Access to Excel fails if one, or more fields is memo/text (data is in SQL
Server). Excel cells can hold 32,767 characters (though they only show
1024), and my memo fields all contain less than 2000 characters, so this
seems to be a bug in Office 2003, since the code worked fine in 2000 and
2002. The error I get is "Overflow" #6.
I'm able to work around this by adding LEFT(memofieldname, 32767) to my
queries, but I'm thinking there should be a fix for this. I've found several
sites where people are reporting a problem with CopyFromRecordset after
upgrading, but no solutions.
Has anyone seen a fix for this problem ? Thanks
Access to Excel fails if one, or more fields is memo/text (data is in SQL
Server). Excel cells can hold 32,767 characters (though they only show
1024), and my memo fields all contain less than 2000 characters, so this
seems to be a bug in Office 2003, since the code worked fine in 2000 and
2002. The error I get is "Overflow" #6.
I'm able to work around this by adding LEFT(memofieldname, 32767) to my
queries, but I'm thinking there should be a fix for this. I've found several
sites where people are reporting a problem with CopyFromRecordset after
upgrading, but no solutions.
Has anyone seen a fix for this problem ? Thanks