I have a similar situation and avoid using DTS or SSIS by first BULK INSERTing the text file into a temp table with one very wide column. Then I SELECT...

That's what I meant to convey. This morning I tried to apply the Jet driver update but it failed because I already have the most recent version--which was applied with...

No spaces in UNC path.

A KB article indicated that version of MDAC was the culprit, specifically, the Jet4.0 component. I tried to update according to the article but the installation...

I tried what you said but I get the same result. I set SQLAgent's proxy account to the same domain service account as the MSSQLService, but no change. This service...

It turns out that all the techniques (Linked Server, OPENDATASOURCE, and OPENROWSET) work just fine with UNCs on my SQL Server 2005 test machine. I read a KB article that...

Yep, that's correct. And SQL Server Service is running under a special domain account that has been given explicit permissions to the share.

Yes. There are no special restrictions placed on the workbook or share. And I do not have this problem with other t-sql operations.

cjb

Unfortunately, I have the same problem with OPENDATASOURCE. It works great as long as the spreadsheet is local...kind of sounds like a share Permissions issue, perhaps.

cjb

Hmmmm...didn't think of the OPENDATASOURCE thing. And it probably doesn't require a Named Range, either. I will definitely try it out.

Thanks, Allen.

Yet another approach is to write to a table, then use sp_OA... stored procedure to create a BulkCopy object and "export" the table to a file. I got this method...

I agree that it is too bad that you did not include bcp and DTS in your analysis. For a simple write to file, though, DTS seems hardly appropriate. And when...

Yes, thank you. That was the problem.

I reconfigured to use Windows Authentication instead of sa. Didn't think to look for that.

Thanks!

That's OK; thanks for trying. I am just as puzzled.

The service account is a domain account. Nevertheless, I tried a different domain account (in sys admin role) as well as a local administrator account. Nothing works.

cjb

No, just the run-of-the-mill SQL Server sa account.

I even set the password back to what it was prior to the change but that has not helped.

cjb