DTS for Excel problem

Hello

I have a problem and need some assistance.
I have a SS that I am loading into a SQL2000 database
I am using DTS for this.
Previously uses used an ADP file to load the spreadsheet.

My problem is that the ADP file uses the ACTIVESHEET for its import.
And the in the DTS you must select the SS you wish to insert.
And the SS name is not standard.

I am trying to use the ADP file and rename the worksheet
any idea how to do this or any idea howelse I can accomplish my goal.

TIA :confused:I will try to help but what does SS and ADP mean? With this explained I can try to help you. :rolleyes:

DePrins
:)|||SS = Excel Spreadsheet within a workbook
ADP = MIcrosoft Access file

I have a spreadsheet with a non specific name
I transfer that file to a shared drive and need to rename the ActiveSheet there. Using access or SQL Server|||Thanks, i will look into it.
:)

DTS Execute SQL task on Access linked table

Can the DTS execute SQL task recognize a table in an Access database that is linked from another Access database?

I'm attempting to use a DTS Execute SQL task connected to Access1.mdb to make a new table in Access1.mdb that is using a Subquery from a linked table in Access2.mdb . (I know it sounds convoluded..) Its giving me an error in my FROM clause as if it can't recognize the linked table from Access2.mdb.

The reason why I'm doing this is that I'm not sure how to run an Access make table query from DTS that will overwrite the existing table in Access. I get an error that the table already exists.

Any Help?You can do testing in query analyzer by placing your select * from openquery statement. If it works in query analyzer then u could execute this sql statement in dts package.

By the way, since you are using DTS package, why not use MS Access connection which is more dynamic and stable than OpenQuery.