deadseasquirrels
Board Regular
- Joined
- Dec 30, 2004
- Messages
- 232
So using recordsets and connections to databases were all working fine until my computer got upgraded to Office 2003 while I was out on jury duty. Now I'm back and my queries won't work. But i figured it out. I have a query tha pulls about 20 columns of data, the 20th column is a comments field (I am pulling from an Oracle DB by the way), so typically it is a huge string. Everytime I pull my data and use the copyFromRecordset command excel throws an error saying
Run-time error '-2147467259 (80004005)':
Method 'CopyFromRecordset' of object 'Range' Failed
Then I deleted the comments field from my db query and tried again, and everything works fine. Now my question is, does anybody have any idea what kind of information could possibly be in the comments field (other than it being really long) that could make CopyFromRecordset fail for Excel 2003 but not for Excel XP? If it is just a matter of length, I would be shocked because i would think an upgrad would upgrade a cell's capacity.
Run-time error '-2147467259 (80004005)':
Method 'CopyFromRecordset' of object 'Range' Failed
Then I deleted the comments field from my db query and tried again, and everything works fine. Now my question is, does anybody have any idea what kind of information could possibly be in the comments field (other than it being really long) that could make CopyFromRecordset fail for Excel 2003 but not for Excel XP? If it is just a matter of length, I would be shocked because i would think an upgrad would upgrade a cell's capacity.