Hi all,

I've checked my configuration with sp_configure and 'Ad Hoc Distributed Queries' value is 1.

And when I exec my script to import Excel data into SQL table it returns this:

Msg 7308, Level 16, State 1, Line 2

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.

The syntax is OK and the Configuration too. So, Why I'm getting that error message?

Thanks in advance.