Welcome to SPN

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

Sign Up Now!

Pulling Data Into Excel from Access

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

  1. Sheenalis

    Sheenalis
    Expand Collapse
    Guest

    I have several queries in Access that are pulling information from our
    central database. I want to pull the query data into Excel. However, I would
    like to be able to create a form in Excel so that we can enter the period and
    year and it will pull that period and year's data from the access queries.
    I've been working with VBA a little bit, but I was wondering if there was any
    easier way to do this? I'm not sure of the best way to link Access and Excel
    for this purpose.

    If anyone has any ideas, they would be appreciated!
    Thanks,
    --
    whitney
     
  2. Loading...


  3. lgalumbres@gmail.com

    lgalumbres@gmail.com
    Expand Collapse
    Guest

    You can add parameters to your query in the column where you want to
    enter a criteria. Open your query in QBE pane in access. In your case
    you would enter parameters in the criteria cells where you have the
    "Period" and "Years" data.

    Heres a link on how to create parameters in ms access:
    http://support.microsoft.com/default.aspx?scid=kb;en-us;304352&Product=acc

    When thats complete, run the query and enter your criteria. Then you
    can export your results as an excel file.

    - Lem

    Sheenalis wrote:
    > I have several queries in Access that are pulling information from our
    > central database. I want to pull the query data into Excel. However, I would
    > like to be able to create a form in Excel so that we can enter the period and
    > year and it will pull that period and year's data from the access queries.
    > I've been working with VBA a little bit, but I was wondering if there was any
    > easier way to do this? I'm not sure of the best way to link Access and Excel
    > for this purpose.
    >
    > If anyone has any ideas, they would be appreciated!
    > Thanks,
    > --
    > whitney
     
  4. Sheenalis

    Sheenalis
    Expand Collapse
    Guest

    Thanks for your response. I actually already have the parameters set and the
    queries all ready in Access. I would like for my boss to be able to enter her
    period and year into a form in Excel and it automatically update the queries
    and pull the data into specific cells in Excel. She's not very fluent with
    Access so it would be much easier for her to operate in Excel without having
    to open Access at all. I have a report currently which was done in a similar
    style using VBA but I'm not quite sure how to do it. Thanks!
    --
    whitney


    "Sheenalis" wrote:

    > I have several queries in Access that are pulling information from our
    > central database. I want to pull the query data into Excel. However, I would
    > like to be able to create a form in Excel so that we can enter the period and
    > year and it will pull that period and year's data from the access queries.
    > I've been working with VBA a little bit, but I was wondering if there was any
    > easier way to do this? I'm not sure of the best way to link Access and Excel
    > for this purpose.
    >
    > If anyone has any ideas, they would be appreciated!
    > Thanks,
    > --
    > whitney
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Link the data in excel?

    Pieter

    "Sheenalis" <Sheenalis@discussions.microsoft.com> wrote in message
    news:33B2416C-EA24-4C4D-B521-B70DBC399AB9@microsoft.com...
    > Thanks for your response. I actually already have the parameters set and
    > the
    > queries all ready in Access. I would like for my boss to be able to enter
    > her
    > period and year into a form in Excel and it automatically update the
    > queries
    > and pull the data into specific cells in Excel. She's not very fluent with
    > Access so it would be much easier for her to operate in Excel without
    > having
    > to open Access at all. I have a report currently which was done in a
    > similar
    > style using VBA but I'm not quite sure how to do it. Thanks!
    > --
    > whitney
    >
    >
    > "Sheenalis" wrote:
    >
    >> I have several queries in Access that are pulling information from our
    >> central database. I want to pull the query data into Excel. However, I
    >> would
    >> like to be able to create a form in Excel so that we can enter the period
    >> and
    >> year and it will pull that period and year's data from the access
    >> queries.
    >> I've been working with VBA a little bit, but I was wondering if there was
    >> any
    >> easier way to do this? I'm not sure of the best way to link Access and
    >> Excel
    >> for this purpose.
    >>
    >> If anyone has any ideas, they would be appreciated!
    >> Thanks,
    >> --
    >> whitney




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4231 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     
  6. lgalumbres@gmail.com

    lgalumbres@gmail.com
    Expand Collapse
    Guest

    I found this thread that maybe could help you out.

    http://groups.google.com/group/micr...base+from+excel&rnum=1&hl=en#7530abc124ab0dc6

    Sheenalis wrote:
    > Thanks for your response. I actually already have the parameters set and the
    > queries all ready in Access. I would like for my boss to be able to enter her
    > period and year into a form in Excel and it automatically update the queries
    > and pull the data into specific cells in Excel. She's not very fluent with
    > Access so it would be much easier for her to operate in Excel without having
    > to open Access at all. I have a report currently which was done in a similar
    > style using VBA but I'm not quite sure how to do it. Thanks!
    > --
    > whitney
    >
    >
    > "Sheenalis" wrote:
    >
    > > I have several queries in Access that are pulling information from our
    > > central database. I want to pull the query data into Excel. However, I would
    > > like to be able to create a form in Excel so that we can enter the period and
    > > year and it will pull that period and year's data from the access queries.
    > > I've been working with VBA a little bit, but I was wondering if there was any
    > > easier way to do this? I'm not sure of the best way to link Access and Excel
    > > for this purpose.
    > >
    > > If anyone has any ideas, they would be appreciated!
    > > Thanks,
    > > --
    > > whitney
     
  7. Sheenalis

    Sheenalis
    Expand Collapse
    Guest

    Thanks so much, I'll check that out.
    --
    whitney


    "lgalumbres@gmail.com" wrote:

    > I found this thread that maybe could help you out.
    >
    > http://groups.google.com/group/micr...base+from+excel&rnum=1&hl=en#7530abc124ab0dc6
    >
    > Sheenalis wrote:
    > > Thanks for your response. I actually already have the parameters set and the
    > > queries all ready in Access. I would like for my boss to be able to enter her
    > > period and year into a form in Excel and it automatically update the queries
    > > and pull the data into specific cells in Excel. She's not very fluent with
    > > Access so it would be much easier for her to operate in Excel without having
    > > to open Access at all. I have a report currently which was done in a similar
    > > style using VBA but I'm not quite sure how to do it. Thanks!
    > > --
    > > whitney
    > >
    > >
    > > "Sheenalis" wrote:
    > >
    > > > I have several queries in Access that are pulling information from our
    > > > central database. I want to pull the query data into Excel. However, I would
    > > > like to be able to create a form in Excel so that we can enter the period and
    > > > year and it will pull that period and year's data from the access queries.
    > > > I've been working with VBA a little bit, but I was wondering if there was any
    > > > easier way to do this? I'm not sure of the best way to link Access and Excel
    > > > for this purpose.
    > > >
    > > > If anyone has any ideas, they would be appreciated!
    > > > Thanks,
    > > > --
    > > > whitney

    >
    >
     

Share This Page