Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $95

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page