Post reply

openrowset error

  • August 25, 2008 at 8:16 am

    #196918

    i am getting below error while executing the openrowset cmd

    can any one please suggest on this one

    Msg 7399, Level 16, State 1, Line 1

    The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.

    Msg 7303, Level 16, State 1, Line 1

    Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

    thanks

    kumar

  • August 25, 2008 at 9:21 am

    #862585

    Without seeing the TSQL statement that you are running, it is difficult to say what the problem may or may not be.

    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

  • August 26, 2008 at 6:13 am

    #863048

    hi,

    actually i want to export data from sql table to excel

    INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',

    'Excel 8.0;Database=d:\pendingdet.xls;',

    'SELECT [ENTRY DATE],PRACTICE,[SCAN FILE],[ACCOUNT #],[PG NUMBER],[P NAME],DOS,SUSPENDED,[NON BILLABLE],REMARKS,RESPONSIBILITY,[RESP REMARSK],OPERATOR FROM [Sheet1$]')

    select entrydt,practice,scanfile,acno,pgnum,ptname,dos,susp,nonb,remarks,responsibility,resp_remarks,operator

    from dbo.[FN_ALL_LOG]('04/01/2008','08/22/2008','tickets') order by scanfile

    GO

    pls do the needfull

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply