Microsoft.ACE.OLEDB.12.0 error

[junkmail]

I have been using the following code for well over a year to import an excel file and it worked perfectly but now all of a sudden I am getting an error. Does anyone have thoughts on what could cause it to stop working.

set @select = 'SELECT * INTO ' +'temptable'+' FROM OPENROWSET('+ ''''+'Microsoft.ace.oledb.12.0'+''''+','+''''+'Excel 8.0;Database='+@path+@filename+''''+', '+''''+'SELECT * FROM [sheet1$]'+''''+@paren

this is the error message I get now.

OLE DB provider "Microsoft.ace.oledb.12.0" for linked server "(null)" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Line 3
Cannot initialize the data source object of OLE DB provider "Microsoft.ace.oledb.12.0" for linked server "(null)

 

[philhege]

Have permissions changed?
Is there a space in the spreadsheet name?

-----------
With business clients like mine, you'd be better off herding cats.

 

[junkmail]

No, Permission have not changed and there is a space in the name but it always has a space every month and it worked fine in the past.

 

[philhege]

Well. If it worked in the past, and doesn't work now, something must have changed to make it not work. That's Troubleshooting 101: What Changed?

-----------
With business clients like mine, you'd be better off herding cats.