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 |
|
sql4sam
Starting Member
5 Posts |
 Posted - 2003-04-20 : 13:13:05
|
| Is it possible to create a DTS package which will import data from MS SQL and then use that data to create a new Microsoft Access database file, or Excel.I know this is possible with a text file using the Text file (destination) and was wondering if I could do the same with other formats which I just mentioned.Appreciate any help! |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-04-20 : 15:29:05
|
| Yes, it's possible.In DTS you have activex scripting which basically allows you to create objects like excel or access and populate them.A good DTS site is www.sqldts.com |
 |
|
|
sql4sam
Starting Member
5 Posts |
Posted - 2003-04-20 : 15:39:34
|
| Again the same situation I am new at this and would really appreciate more help.Thanks! |
|
|
|
sql4sam
Starting Member
5 Posts |
Posted - 2003-04-20 : 16:14:36
|
| Ok it seems that I overlooked there is an article about creating a new access database (my fault). But how would this work for excel?!Thanks again! |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-04-20 : 17:31:58
|
| You would create an Excel object as suchDim objExcel As ObjectSet objExcel = CreateObject("Excel.Application")Then you can create a workbook and worksheets and dump your data via ADO.I suggest getting O'Reilly's book called Excel Macros which covers Excel VBA and the Excel object model.Also why can't you create and Excel spreadsheet with some ADO logic that connects to your SQL Server and extracts the data????Seems like it would streamline the process of having to create the spreadsheet. You'd be pulling the data instead of pushing it.Additionally, if you're using this for reporting purposes you may want to look into Crystal Reports or Business Objects. SQL Server Reporting Services comes out along with SQL Server Yukon but that would also be something you want to look into.Edited by - ValterBorges on 04/20/2003 17:36:17 |
|
|
|
|
|
|
Using DTS to create new (database or spreedsheet)