M
michael.beckinsale
Hi All,
This is the situation l currently have:
1) Financials database tables, linked to Access, Access query tables
to extract data, Access crosstab query to get data in layout req'd.
Result imported in Excel.
This is what l would like to do:
2) Financial database tables, query table into Excel, crosstab query
in Excel.
I know how to download the financial tables using ADO & SQL so l my
questions re 2) are as follows:
a) I assume that the results of the intial query have to be written to
an Excel sheet
b) Can l then use a SQL statement within VBA to create a sheet with
the results of the crosstab query?
c) If b) can be done does anybody have any example code please?
c) Will 2) be quicker / more efficient than 1)
I have been told by a database expert that because of the layout of
the tables within the financial database a single query cannot give
the desired result. I am not an expert on SQL.
I hope l have explained myself clearly.
All advice gratefully received.
Regards
Michael beckinsale
This is the situation l currently have:
1) Financials database tables, linked to Access, Access query tables
to extract data, Access crosstab query to get data in layout req'd.
Result imported in Excel.
This is what l would like to do:
2) Financial database tables, query table into Excel, crosstab query
in Excel.
I know how to download the financial tables using ADO & SQL so l my
questions re 2) are as follows:
a) I assume that the results of the intial query have to be written to
an Excel sheet
b) Can l then use a SQL statement within VBA to create a sheet with
the results of the crosstab query?
c) If b) can be done does anybody have any example code please?
c) Will 2) be quicker / more efficient than 1)
I have been told by a database expert that because of the layout of
the tables within the financial database a single query cannot give
the desired result. I am not an expert on SQL.
I hope l have explained myself clearly.
All advice gratefully received.
Regards
Michael beckinsale