|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Thursday, February 05, 2009 8:21 PM
Points: 3,
Visits: 35
|
|
i want to select data from csv file , use following command
select *
from OpenRowset('MSDASQL',
'Driver={Microsoft Text Driver (*.csv)};
DBQ=C:\myFolder\',
'select * from myFile')
but it giving following error message
OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".
how i add referece of MSDASQL ?
how i solve this problem ?
Thanks in advance
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Thursday, September 03, 2009 10:37 AM
Points: 271,
Visits: 442
|
|
Did you try creating a Linked Server?
|
|
|
|
