I have recently installed SQL express 08 and created a table to import excel data into. Im running on a windows 7 64 bit OS i5 processor.
I've disabled the firewall (temporarily) and will set the necessary ports once this is working.
I run the following query: (which i found from multiple sources on the net)
'Select * From [sheet1$]'
and receive the following message:
Msg 7308, Level 16, State 1, Line 1
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. (how did they know i was single and living in an apartment? lol)
so after research of the following message i restarted the system and relaunched man
View Complete Post