ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating Excel Documents from Scratch. (https://www.excelbanter.com/excel-programming/392226-creating-excel-documents-scratch.html)

bryan_homey

Creating Excel Documents from Scratch.
 
I am exporting out Raw Data from a SQL Server DB and want this data to be
easily read by Excel 2003. I have scripts that need to run to get the
correct info out and emailed, so just using the ODBC connection isn't going
to work. Any suggestions other than creating a C# program?

Thanks

NickHK

Creating Excel Documents from Scratch.
 
If it is only data, Excel can open CSV files.
Or Excel/VBA can query the database directly.

Depends what happens in the SQL Server Email steps.

NickHK

"bryan_homey" wrote in message
...
I am exporting out Raw Data from a SQL Server DB and want this data to be
easily read by Excel 2003. I have scripts that need to run to get the
correct info out and emailed, so just using the ODBC connection isn't

going
to work. Any suggestions other than creating a C# program?

Thanks





All times are GMT +1. The time now is 10:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com