Export Data from db to an excel file.

[xjy]

I use .asp to create an excel file on the server side.
then I export some date from a database to it. All code
works well until Excel application runing on the server
side.
So, you need shut down the excel on the server side and
run it no more, then you can let client to create an excel
file through .asp successfully.

Why?
How to deal with it?

Thanks in advance

 

[keepITcool]

ADO has trouble with open excel files
(KB319998)
Memory Leak Occurs When You Query an Open Excel Worksheet Using ADO


Alternatively use syntax like
SELECT * from db INTO \\temp\book.xls

this creates the excel file.
THEN rename, open, format and present to user.


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Jamie Collins]

use syntax like
SELECT * from db INTO \\temp\book.xls

this creates the excel file.

More like (pseudo):

SELECT * INTO [book.xls].RangeAddressOrName FROM db

and only works for (some) Jet connections.

Jamie.

--