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 |
|
Andy Verity
Starting Member
12 Posts |
 Posted - 2003-06-27 : 04:39:11
|
| I am trying to set up a DTS connection o Excel programatically within VBA. To get some ideas I set one up in Exchange Server and saved it as a dts file which I loaded into vba as a package. Checking the connection details it used the Microsoft Jet Datasource but had extended properties which applied the Excel setup.Does anybody have any ideas how to do this or documents that cover this? |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-30 : 19:49:50
|
| Yeah, don't do it and use a stored procedure, or save a package in SQL Server.And by all means keep it simple.Just remeber all the rockect science today is just a maint nightmare tomorrow.MOOBrett8-) |
 |
|
|
|
|
|
DTS Connection to Excel