Yes... here is now the error..

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "External table is not in the expected format.".

Msg 7303, Level 16, State 1, Line...

I tried creating a file on my local drive and getting this error..

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

...

I read somewhere that SSMS is 32 bit even if you have 64 bit of SQL Server so I guess it's not the culprit.

Hi Sachin,

I tried your suggestion but I'm still getting this error:

Msg 7399, Level 16, State 1, Line 2

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The...

how I allocate or adjust memory for linked server?

physical memory is default in sql server.. 2147483647 ... excel file is only 26KB

physical memory allocated is the default in sql server. Excel file size is only 26 KB.

Yes, it is enabled

Tried it (ACE) and now I'm getting this error:

Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".

yes, SQL Server is 32 bit. Server's memory is 8GB.

Yes..

all are 32 bit. But still getting that error.

there is also an oledb on that machine...

My machine which I remotely access databases that has SSMS is 64 bit.

Database server is 32 bit. SQL Server is 32 bit

Office installed...

it executed successfully on a one 32 bit machine and didn't run on another 32 bit machine.

Maybe something to configure? or add on that machine to make it work?

Thanks!

so when I access my databass on my machine using ssms and run queries, It uses my machine's Jet and not the one on database server?