Export Data from db to an excel file.

X

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
 
K

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 >
 
J

Jamie Collins

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

this creates the excel file.
Click to expand...

More like (pseudo):

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

and only works for (some) Jet connections.

Jamie.

--
 
Top