|
|
|
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?
|
|
|
|