output to a table... Pl help. Thanks

[gdanalakshmi]

How do I output a query to a table?

 

[Jack Cowley]

With a Make Table query...

hth,
Jack

 

[gdanalakshmi]

It is a parameter query and I would like to construct a temporary table by running the query in the VBA code.

 

[Jack Cowley]

You can create a recordset from the query to get the data that you want to use if you like. I am not sure what it is you are trying to do so I am not sure what to suggest.... If you want a temp table then make it a Make Table query and then delete the table when you are finished with it.

Jack

 

[gdanalakshmi]

Actually I have created a report in my company . The report has a title and a totals that is a total of column 3 of the query.

Since,I was asked to generate a excel output so that we can send to the customer. My excel file should match the contents of the report ie the title in the beginning and the totals at the end.
I tried to output the report to the excel and there was no title and no totals. Since I donot know how to do that, I thought I will construct a temporay table and insert what ever I wanted into the table and outout the table directly to excel.


I am clearly conveying??
Is there a better way to do this??

Thanks

 

[Jack Cowley]

You are clealy conveying! Now that I understand what it is you want to do we have gone beyond my area of knowledge. I suggest that you repost your question and explain what is is you want to do and someone with expertise in Access and Excel will be able to help you.

Jack

 

[neileg]

You can't do this simply. The functions in Access that generate the Excel output only include the data, and not titles or header and footer info, except for totals in the footers. Thus any output you generate, whether from a table or a report is going to suffer from this limitation.

If you publish the report to Word format (actually .rtf) you will preserve the titles, etc. Will this do?

If you really need to do this, you will have to create a series of files in Access, and read these into an Excel template. It is possible, but it's a long way from the Excel wizard!

 

[gdanalakshmi]

How Do i send the totals to the excel sheet???

Can u please tell that???

 

[neileg]

From the Access 2000 help file. Italics are mine.

If you output the data in a report, the only controls that are included in the output file are text boxes (for .xls output files), or text boxes and labels (for .rtf, .txt, and .html output files). All other controls are ignored. Header and footer information is also not included in the output file. The only exception to this is that when you output the data in a report to a Microsoft Excel file, a text box in a group footer containing an expression with the Sum function is included in the output file. No other control in a header or footer (and no aggregate function other than the Sum function) is included in the output file.