BorlandTalk.com

Jorge Novoa · Guest

The problem is the next:
I tried to retrieve data from a tquery to a excel sheet:
excelsheet.cells.item[i,j]:=query1.fieldbyname('fieldname').asstring
..
..
when that lines execute raise an Ole Error.

After a while tinking about it, i change the way to pass the data to excel. I first passed data from tquery to stringgrid and then from strnggrid to excel:
procedure tosgrid()
....
stringgrid1.cells[i,j]:=query1.fieldbyname('fielname1').asstring
...

procedure toexcel()
...
excelsheet.cells.item[i,j]:=stringgrid1.cells[j,i];
...

executing above procedures, no error where raised.
why that happens?, its some strings type incompatiblity there?.
The problem could be in the time procedures takes to executing when pass large data amounts.
hope understand