Tried it:

EXEC sp_addlinkedserver 'ExcelSource',

   'Jet 4.0',

   'Microsoft.Jet.OLEDB.4.0',

   'C:\Documents and Settings\RS02130\Desktop\OLS Requests.xls',

   NULL,

   'Excel 8.0'

GO

EXEC sp_addlinkedsrvlogin 'ExcelSource', False, null, null, null

GO

select * from ExcelSource...OLS

Result is:

Server: Msg 7399, Level 16, State 1,...

Can anyone explain why I would have to have a login for an Excel Spreadsheet? At best I would think "False, Null, Null, Null" would work. Excel doesn't do any...

You can do it without the first task if you just use a couple more FSO properties and methods:

ActiveX Task:

'Parse folder contents for files from today

Dim fso...

But doesn't giving the user the SA Server role give them the ability to change their own permissions? Doesn't this create a huge security hole?

You can use an ActiveX task with VBScript and the File System Object to look at the files' DateCreated property, get the file name and modify the import task's Source...

This whole thing was sparked by a need to take all the tasks on my Outlook calendar (that's how I keep track of all...

Bill, I'm not familiar with using the Execute SQL task that way. How do I get the output from the SP into a temp table that I can pass to...

There was a PRINT statement hidden in the original code I purloined for the SP. Once I got rid of that the Preview button...

According to MS there are "several" vendors working on programs to translate Crystal Reports RPT files to Reporting Services format. I heard there might be something available in 3Q2004. Of...

A new and very complete FTP Custom Task was posted on http://www.sqldts.com. I downloaded and implemented it and it's great.

Good post from the point of a paranoid security wonk. They restrict xp_availablemedia which is required to use Bulk Insert and they restrict xp_sdidebug which is required for debugging of...

I had several versions of this I picked up from various sources and I was able to get one of them working. I need to look and see if there's...

I was in VB6. Since there was no project file I had to set the Project Properties to ActiveX DLL, No Startup, Set the Project Name, then it let me...

I opened the CLS file in Visual Studio and updated the functions and API calls based on the WinInet doc. Then I went looking for the option to build a DLL...

The link you posted points to code that's executed in T-SQL which would require using a SQL Task in DTS with all the code buried in it. Plus the example...