Export results to an access database

[funkmonsteruk]

I'm creating daily reports with bank balance figures, which i need to compare on a daily bases with the previous days figures.

I'm guessing the easiest way to do this is to export the data to an access database and run a query from there (can't use historic data from a single bo report as this will give incorrect values).

Does anybody know how to either export to an access database or alternatively export to a new worksheet or part of an existing worksheet in excel...?

Funkmonsteruk

 

[PruSQLer]

Funk,

I just click the data cube, then click the Export button and specify a location to send the txt file to. Then I import the file to either Access or Excel. Is that what you meant?

 

[funkmonsteruk]

Kinda, need to automate the report using VBA and also need to export to a either a new table in an existing database or a new sheet in an existing workbook....

 

[funkmonsteruk]

When trying the export function does not offer choice of exporting to an .mdb format, if i try and force the issue by adding mbd as file extension the resulting database gives an unrecognised data format when i try and open it

 

[blom0344]

Hello Funk,

Let's get some things straight. An .MDB file is the database itself, not a table within it. Another thing is that you are taking the long way to get information into Access, the step involving BO is totally superfluous. If you take the SQL that BO uses and create a table-build query in Access , you can use ODBC to get the data directly from your database to Access.(much faster!!) You probably have to rewrite the ANSI-SQL to JET-SQL Access uses or try it as a pass-through query on the database with the original ANSI SQL. Wrap everything in a macro and assign a button on a swithboard to run the macro and have everything in the push of a button. Which RDBMS do you use? T. Blom
Information analyst
tbl@shimano-eu.com