Page 1 of 2 12 LastLast
Results 1 to 15 of 23
  1. #1
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130

    Unhappy Unanswered: Nothing to do with Sp_Configure (was "Sp_configure")

    I have enabled the permissions and execute the following code getting the following error but i can't understand can any body help me plz
    Code:
    SELECT * INTO Tenantdetails
    FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
    'Excel 8.0;Database=d:\Tenantdetails.xls', 'SELECT * FROM [Tenantdetails$]')
    error is
    Code:
    Msg 7357, Level 16, State 2, Line 1
    Cannot process the object "SELECT * FROM [Tenantdetails$]". The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object.
    plz help me i am confused

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    So there is a file named Tenantdetails.xls in the root folder of the SQL Server's D: drive?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130
    yes there is a xl file name Tenantdetails

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    And it contains a worksheet called Tenantdetails?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130
    In the file tenantdetails sheet1 has the data

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Code:
    SELECT * INTO Tenantdetails
    FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
    'Excel 8.0;Database=d:\Tenantdetails.xls', 'SELECT * FROM [Sheet1$]')
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130
    wow its amazing i have trying from the past 7 hrs but finally got it by your help thanks a lot Mr.pootle flump really surprised by the result

  8. #8
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130

    Thumbs up


  9. #9
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Pootle, you need to change your signature to this:
    wow its amazing i have trying from the past 7 hrs but finally got it by your help thanks a lot Mr.pootle flump really surprised by the result
    I like the way it sounds
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  10. #10
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    cool beans Robert
    Testimonial:
    pootle flump
    ur codings are working excelent.

  11. #11
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I keep on hitting this thread in hope of something interesting, but there is absolutely nothing about SP_CONFIGURE!!! Do people pay attention to what they put in the thread title, and what is the "local police" doing about these "misleading" titles?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  12. #12
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130
    Quote Originally Posted by rdjabarov View Post
    I keep on hitting this thread in hope of something interesting, but there is absolutely nothing about SP_CONFIGURE!!! Do people pay attention to what they put in the thread title, and what is the "local police" doing about these "misleading" titles?
    they were searching
    WiTh Tnks & ReGaRdS
    mAtHuKuMaLi

  13. #13
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by rdjabarov View Post
    what is the "local police" doing about these "misleading" titles?
    Local police were busy queuing for doughnuts.

    Hope you like the title
    Testimonial:
    pootle flump
    ur codings are working excelent.

  14. #14
    Join Date
    Jul 2010
    Location
    ISHHHH
    Posts
    130
    its surprised to see the title i was stunned
    WiTh Tnks & ReGaRdS
    mAtHuKuMaLi

  15. #15
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Hmmm...I followed all the way through this thread, but am unable to find any link to "Robert" for which I can resist the temptation to click.

    I am upset that the title of the thread apparently has nothing to do with the content.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •