using excel control in visual basic 6

[spumbu1977]

hi

i hope you can help

i am currently trying to paste a text file into an excel spreadheet control from within vb6 and am having no luck

the text file is created by a sql string which reads from a sql database and is unfortunately not delimeted in the text file creation however it is possible to do delimetation after it has been pasted in to excel itself , but the proble i am having is copying it into vb6 excel component

can anyone offer any opinions or examples that might be able to help

thanks in advance

Rob

 

[XLGibbs]

You may be able to convert the text file and read it in list view and convert the send the list items to the excel sheet as an alternative option.

You would create an excel object using the excel object library, and you can write to that object by setting the ranges etc using that object model