Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
srxr9
Starting Member
15 Posts |
 Posted - 2006-10-02 : 14:30:25
|
| What is the best way to export tables dynamically to Excel without having the Excel template created? I see couple of threads regarding Export to Excel, but all the methods require an Excel Template and the data from the table is inserted into the Excel Sheet.But I would like to know if there is any method that dynamically creates the Excel sheet and populates it.I am trying to export table to Excel, that will have different field names for different clients. What is the best way to accomplish this?ThanksSuresh |
|
|
TimothyJames
Starting Member
2 Posts |
Posted - 2006-10-03 : 05:20:13
|
| Have you tried using DTS?________HTH |
 |
|
|
|
|
|
export tables dynamically to Excel