Oh, OK.  I thought you meant that you created the Excel file from within a SQL Task. 

Thanks

RitaBowman -- just wondering, how did you accomplish creating an Excel file via a SQL Task?

Thanks,

Brian

Another thing to keep in mind here is:  "Do the names of the files change?"  If so, you will have to account for this in the DTS, probably using an...

A timeout value of 0 means "unlimited".  With this value, a query should never timeout.  Concerning the update statement, turn on logging in the DTS to see what is happening...

If you have a pivot table that currently uses external data, then you simply need to add the code below...

    Private Sub Workbook_Open()

        ActiveWorkbook.RefreshAll

    End Sub

It's more complicated if you...

The code below (ActiveX Script) shows how to create a text file and write to it using FSO.  Simply add some ADO code to execute the query and generate a...

We have reports in Excel (primarily pivot tables) that are auto-refreshed when the workbook is opened.  We simply added some code to perform the refresh when the Workbook_Open event is...

Check out the FAQ on this site...

http://www.sqlservercentral.com/faq/

Check out this site for various forms of connection strings...

http://www.connectionstrings.com/

Try using the "OpenArgs" method of the OpenForm action...

Syntax

DoCmd.OpenForm formname[, view][, filtername][, wherecondition][, datamode][, windowmode][, openargs]

For Example:

DoCmd.OpenForm "yourOpenForm", , , , , , InfoYouWantToPassToNextForm

Then when the next form opens, use...

We have a job that runs and populates a table and we query the table to generate a weekly report.  The job executes the following statement...

insert into yourDB.dbo.yourTableName (db, fileID,...

If you're doing this from within Access, you can use the RegisterDatabase method, like below...

    strAttributes = "Database=yourDBname" & vbCr _

                  & "Description=yourDescription" & vbCr _

                  & "OemToAnsi=No" & vbCr...

As AJ Aherns suggests, start by creating queries in Access and then viewing them in "SQL View".  This will show you how Access creates queries. 

Be aware though that Access...

We had an issue where our Access code appeared to execute faster than what our LAN could handle and we had to add code to actually have the application pause for...

As Osoba stated above, check that the SQL Agent has the same privileges that your user account has, otherwise the job will fail, because a job is run using the...