Importing Data into SQL Server Express
- Hi I have SQL Studio Management Express and I would like to import
data from Access, Excel, and .txt files. Does anyone know a query that
can accomplish that? This is the code I used, and the error I received.
'C:\Documents and Settings\All Users\Documents\Access
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)"
returned message "Could not find installable ISAM.".
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider
"Microsoft.Jet.OLEDB.4.0" for linked server "(null)".