Data Connections

[cstimart]

Using Office 2007:

I have an Access db with a handful of queries. Is it possible to "connect" the database to Excel and have the data from the queries on separate tabs?

I've tried to do so and only the 1st query returns data within Excel.

 

[GlennUK]

Can you describe exactly what you've done in the separate tabs?

 

[cstimart]

Tab 1 isn't anything special, it will be a "recap" sheet. Tab 2, I connected to Access db and pulled in the table from my 1st query. On Tab 3, I tried to do the same for the 2nd query but I only got the header and 1-2 empty lines in the table.

 

[GlennUK]

What are the details for the 2 queries? Did you do the connect the same way both times?

 

[cstimart]

What are the details for the 2 queries? Did you do the connect the same way both times?

Yes, I tried to connect Tab 3 the same way as Tab 2.

Data/From Access...picked .accdb...then picked query as a Table to an existing worksheet.

 

[GlennUK]

In that case it should have worked. Did you experiment with other queries in Tab 3? Maybe even try the same query as in Tab 2, to see if it works?

 

[cstimart]

In that case it should have worked. Did you experiment with other queries in Tab 3? Maybe even try the same query as in Tab 2, to see if it works?

Yep...I tried a couple others and got the same results...nothing. I can't get more than query/table to populate in excel at a time.

 

[cstimart]

So I gave it another whirl. I was able to get 2 tables to populate from Access and any further were empty tables. In addition, the 1st table only populated 24 of the 48 records in the Access query!