Query Table - weird results
 

Hi All,
I'm using Excel's querytable object to export data to excel thru a VB
program.
It works most of the time but sometimes i get some weird result while
exporting a recordset to excel.
On some systems though the Refresh Method of Querytable object retains
TRUE without any error, the data
doesn't reflect in the worksheet. I checked my recordset and all the
properties of QueryTable and found them
all right.
The interesting thing is that when i import the same data from Excel's
"Get External Data" Feature i get the
desired output.
Can anybody figure out whether it's problem with excel or something
else.

Thanks in Advance

Sandeep

Query Table - weird results
 

I got to know the reason behind this...but not very sure...
Earlier i was creating the excel object dynamically as my project was not
having the reference of Excel library ...
but as soon as i made the object of excel ( application , workbook ,
worksheet ) static it worked!!!!
Any other suggestions???

"sandeep" wrote in message
...
Hi All,
I'm using Excel's querytable object to export data to excel thru a VB
program.
It works most of the time but sometimes i get some weird result while
exporting a recordset to excel.
On some systems though the Refresh Method of Querytable object retains
TRUE without any error, the data
doesn't reflect in the worksheet. I checked my recordset and all the
properties of QueryTable and found them
all right.
The interesting thing is that when i import the same data from Excel's
"Get External Data" Feature i get the
desired output.
Can anybody figure out whether it's problem with excel or something
else.

Thanks in Advance

Sandeep