Pulling Data Into Excel from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
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
 
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!
 
Link the data in excel?

Pieter

Sheenalis said:
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!
Click to expand...



--
 
Back
Top