Link to Access Report Total to Excel Workbook?

[GSCaupling]

MS Office 2007 Professional.

I have a set of linked Excel workbooks: Payroll, Commissions and Payables. The Payables workbook is linked to the other two and updates automatically. The client looks at this frequently to see how much cash he can take out of the business.

I am building an Access database to replace the Commissions workbook.

Is there any way for the Payables workbook to link to the commission totals computed by Access?

Thanks,
GS

[Green]******^*******
[small]I[/small] [small]Hate[/small] [♥] [small]Ambiguity.[/small][/green]

 

[SkipVought]

Hi,

Totals ought to be able to be calculated in Excel by querying your Access DB via MS Query.

Data > Get External Data > For Other Sources > From Microsoft Query

In Choose a Data Source select MS Access Database* adn drill down to your DB.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[GSCaupling]

Thanks Skip. I've never tried that before (I've never had the need) so it looks like I'll be learning something new this weekend.

GS

[Green]******^*******
[small]I[/small] [small]Hate[/small] [♥] [small]Ambiguity.[/small][/green]