阅读背景:

使用数据库中的ADOB连接处理数据到Excel时,除以零错误

来源:互联网 

I was trying to call sql query from a macro and getting division by zero error. The same macro works when i run a small query. The query is huge and has multiple select statements. I have included 'Set Arithabort On' and 'Set Arithabort off in my SQL query. The macro is generating headers from the SQL table but not the data when i am using CopyFromRecordset to spreadsheet. Please let me know if you need more information. I was trying to call sql query from a macro and




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: