Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How do I open a sql server database on my local machine in Access

Discussion in 'Information Technology' started by mleeber, Jul 28, 2006.

  1. mleeber

    mleeber
    Expand Collapse
    Guest

    I have a sql db file on my laptop. I am not running any sort of server based
    app. Can I get the data out of the sql db via access?

    Thanks!
     
  2. Loading...


  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    If Access is also installed, you can directly link to the SQL-Server tables
    using OLEDB or ODBC. It is easy to create an ODBC connection by building one
    using the ODBC Data Source Administrator built into Windows:

    Control Panel ... Administrative Tools ... Data Sources (ODBC)
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "mleeber" <mleeber@discussions.microsoft.com> wrote in message
    news:7994ABD8-02C1-4F74-AE7C-C54C1D19162C@microsoft.com...
    >I have a sql db file on my laptop. I am not running any sort of server
    >based
    > app. Can I get the data out of the sql db via access?
    >
    > Thanks!
     
  4. mleeber

    mleeber
    Expand Collapse
    Guest

    Re: How do I open a sql server database on my local machine in Acc

    which tab under the ODBC administrator do I add the connection in?

    THanks!

    "Arvin Meyer [MVP]" wrote:

    > If Access is also installed, you can directly link to the SQL-Server tables
    > using OLEDB or ODBC. It is easy to create an ODBC connection by building one
    > using the ODBC Data Source Administrator built into Windows:
    >
    > Control Panel ... Administrative Tools ... Data Sources (ODBC)
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > "mleeber" <mleeber@discussions.microsoft.com> wrote in message
    > news:7994ABD8-02C1-4F74-AE7C-C54C1D19162C@microsoft.com...
    > >I have a sql db file on my laptop. I am not running any sort of server
    > >based
    > > app. Can I get the data out of the sql db via access?
    > >
    > > Thanks!

    >
    >
    >
     
  5. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    Re: How do I open a sql server database on my local machine in Acc

    "mleeber" <mleeber@discussions.microsoft.com> wrote in message
    news:FB6D92F2-9EA5-4780-9E80-F66605AA3FE5@microsoft.com...
    > which tab under the ODBC administrator do I add the connection in?
    >
    > THanks!


    The responder likely missed the fact that you don't have sql server
    installed on your local machine. You do need to install sql server on your
    machine to be able to read, and open the sql data file....

    You can also install the free desktop version of sql server (there is a copy
    on each office cd).

    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal
     
  6. mleeber

    mleeber
    Expand Collapse
    Guest

    Re: How do I open a sql server database on my local machine in Acc

    Thanks Albert! I was afraid I had to have an Instance of SQL server running
    somewhere. I will check out my office CD for the desktop version.

    "Albert D.Kallal" wrote:

    >
    > "mleeber" <mleeber@discussions.microsoft.com> wrote in message
    > news:FB6D92F2-9EA5-4780-9E80-F66605AA3FE5@microsoft.com...
    > > which tab under the ODBC administrator do I add the connection in?
    > >
    > > THanks!

    >
    > The responder likely missed the fact that you don't have sql server
    > installed on your local machine. You do need to install sql server on your
    > machine to be able to read, and open the sql data file....
    >
    > You can also install the free desktop version of sql server (there is a copy
    > on each office cd).
    >
    > --
    > Albert D. Kallal (Access MVP)
    > Edmonton, Alberta Canada
    > pleaseNOOSpamKallal@msn.com
    > http://www.members.shaw.ca/AlbertKallal
    >
    >
    >
     
  7. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Re: How do I open a sql server database on my local machine in Acc

    "Albert D.Kallal" <PleaseNOOOsPAMmkallal@msn.com> wrote in message
    news:OTIIKgjmGHA.4772@TK2MSFTNGP04.phx.gbl...
    >
    > "mleeber" <mleeber@discussions.microsoft.com> wrote in message
    > news:FB6D92F2-9EA5-4780-9E80-F66605AA3FE5@microsoft.com...
    >> which tab under the ODBC administrator do I add the connection in?
    >>
    >> THanks!

    >
    > The responder likely missed the fact that you don't have sql server
    > installed on your local machine. You do need to install sql server on your
    > machine to be able to read, and open the sql data file....
    >
    > You can also install the free desktop version of sql server (there is a
    > copy on each office cd).


    You can read or write to a SQL-Server file running on a remote server (using
    port 1433) with an ODBC connection with an MDB. If you have an ADP, you can
    directly open and manipulate the remote file. You do not need the file on
    the local machine at all.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access
     
  8. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    Re: How do I open a sql server database on my local machine in Acc

    >. You do not need the file on the local machine at all.

    Unfortunately, the poster states that they don't have sql server, nor access
    to the remote server where the data came from.

    All they have is a local sql data file on the notebook. Ms-access can't open
    that....

    Without question, your suggestion to connect to the sql server is the best
    choice, but that assumes they have access to the server, and from what I can
    see the OP does not.

    I would have to say that the person sending the data should at least export
    from the sql server to excel, or ms-access BEFORE sending the file.

    Receiving a raw sql server data file is not very useful...and can't be
    opened by much of anything except sql server.

    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal
     

Share This Page