Data from many tables to one excel sheet

  • Thread starter Thread starter Asdis via AccessMonster.com
  • Start date Start date
A

Asdis via AccessMonster.com

Hi,

Maybe someone can help me with my problem.

I have a few tables in one database, one per customer. Every table has the same structure; four fields where the first two fields are the primary key (date and time) and the other two relate directly to the primary key of course but are not dependent on each other.

What I want to do is the following:

Get data from a certain period of time from all these tables and place it in one table in Excel.

I know how to get the data from Access to Excel for one table at a time (even thought Excel for some reason doesn't sort the data ascendingly) but to get it from all the tables I can't figure out.

I hope you understand my question and that maybe someone can help me ;)

Asdis
 
Hi,

Maybe someone can help me with my problem.

I have a few tables in one database, one per customer. Every table has the same structure; four fields where the first two fields are the primary key (date and time) and the other two relate directly to the primary key of course but are not dependent on each other.

What I want to do is the following:

Get data from a certain period of time from all these tables and place it in one table in Excel.

I know how to get the data from Access to Excel for one table at a time (even thought Excel for some reason doesn't sort the data ascendingly) but to get it from all the tables I can't figure out.
Click to expand...
goto to the Query design
play around till the Query gives you what you want and then export the
query to Excel

BTW: a table has no sorting at all
 
Hmmm.... So it is not possible to write a macro in Excel to do this? I don't think that the query approach suits my needs...

What I had in mind was to somehow take one date+time combination and for that combination to search throught all my tables for data belonging to that particular combination. Then take the next date+time combination and do the same etc.

And it's ok if it isn't properly sorted, just as long as the correct data sticks with the right date+time combination... Then I can just sort it manually afterwards...

Hope someone can help me... ;)
 
you can do this with microsoft query.
data>get external data>new database query.
follow the wizard.
I use it all the time.
-----Original Message-----
Hmmm.... So it is not possible to write a macro in Excel
Click to expand...
to do this? I don't think that the query approach suits my
needs...
What I had in mind was to somehow take one date+time
Click to expand...
combination and for that combination to search throught
all my tables for data belonging to that particular
combination. Then take the next date+time combination and
do the same etc.
And it's ok if it isn't properly sorted, just as long as
Click to expand...
the correct data sticks with the right date+time
combination... Then I can just sort it manually
afterwards...
 
Back
Top