Rick L.


Hello does anybody know how to convert an SQL Server file into a DBF or an Excel sheet I need to do this programmitically with C# or python. Preferrably C#. Also, the converted file must be placed into a different folder. Thanks.



Re: Convert SQL Server into DBF or Excel

Arnie Rowland


This should help with the Excel output.

Export data to Excel
http://www.mssqltips.com/tip.asp tip1202







Re: Convert SQL Server into DBF or Excel

Jens K. Suessmeyer

Well actually, there is no built in way for doing this. What about using the DTS Wizward of SQL Server Excel is not the appropriate tool as it only supports (depending on the version of excel) up to ~65k rows. Doing this programmatically would imply doing it all one by one.


Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---