SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Mar 2010
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQL import to Excel 2007

    Hello,

    I've read posts and searched how I would be able to import Excel to SQL, but how would I import SQL to Excel?

    When i'm in Excel i go to Data>>From Other Sources>>From SQL Server.
    In the Server name i've enter the IP address but, i can never bypass this screen. I receive this error when i use either log on credentials:

    "[[DBNETLIB]][ConnectionOpen(Connect()).]SQL Server does not exist or access denied."

    Does anyone know how to fix this? Or am i not able to import from a remote access? Many thanks in advance

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,653
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    You can import just about any SELECT query if you can hit the server, but it sounds like you can't access the server directly. I'd get with the persons responsible for networking and the server and figure out why.


Tags for this Thread

Bookmarks

Posting Permissions

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