OpenRowset reading from flat file

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

OpenRowset reading from flat file

Author

Topic

GhantaBro
Posting Yak Master

215 Posts

Posted - 2009-07-22 : 20:26:50

This is what I did using script from one of the posts:

EXEC dbo.sp_AddLinkedServer TxtSvr,
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'E:\campaignexport\campaign_data_file\',
NULL,
'Text'

EXEC dbo.sp_AddLinkedSrvLogin TxtSvr, FALSE, NULL, Admin, NULL

SELECT *
FROM TxtSvr...hh_pipe_file#dat

I tried using openrowset and I get this error:

The OLE DB provider "MSDASQL" has not been registered.
Not sure Why I am getting this? Am I doing something wrong?

GhantaBro
Posting Yak Master

215 Posts

Posted - 2009-07-22 : 20:38:33

I tried this for a pipe delimited file:

select * from OPENROWSET('MSDASQL',
'Driver={Microsoft Text Driver (*.dat; *.csv)};
DEFAULTDIR=E:\campaignexport\campaign_data_file\;Extensions=DAT;',
'SELECT * FROM hh_pipe_file.dat')

Error I got:
Msg 7403, Level 16, State 1, Line 2
The OLE DB provider "MSDASQL" has not been registered.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources