Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a xls File on Server without Excel?
hi i have to export some databases to a xls File with DTS and VBA on
MIcrosoft SQL Server 2000. in Dts it is not very difficult but i have to do this dynamicly. So have to create a new xls File with Scripting FileSystemObject but on the server is no Excel Application. u know how i can do this? i have mayby a solution but then i have to delete the value of the fil before a job, otherwise the file will be bigger and bigger. any ideas? th -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a xls File on Server without Excel?
Milosz wrote ...
hi i have to export some databases to a xls File with DTS and VBA on a MIcrosoft SQL Server 2000. in Dts it is not very difficult but i have to do this dynamicly. So i have to create a new xls File with Scripting FileSystemObject but on the server is no Excel Application. u know how i can do this? You can use the Microsoft OLE BD provider for Jet to dynamically create an Excel workbook. Specifying a non-existent but valid path, workbook name and Excel 'table' in a SELECT..INTO query results in it being created. See: Microsoft Knowledge Base Article - 295646 HOWTO: Transfer Data from ADO Data Source to Excel with ADO http://support.microsoft.com/default...;en-us;Q295646 However, I have so far been unable to do the same when using the SQL Server provider and specifying a non-existent Excel element using either the OPENROWSET or OPENDATASOURCE functions. Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
recovering deleted excel file from server | Excel Discussion (Misc queries) | |||
Run Excel file on a Server | Excel Discussion (Misc queries) | |||
Script to save Excel file to the server. | Excel Discussion (Misc queries) | |||
How do I use a server name in an Excel chart file path? | Charts and Charting in Excel | |||
Save Excel file at server? | Excel Programming |