exporting to excel

[akrylik]

What is the best way to export data from Access to Excel. We are doing calculations and would like the value of the calculation to go into a specific field in excel. Is there a way to do that, or would it be easier to just create a new table to place the values in and then export the table itself to excel?

[winterh]

Total upto you, I do the same type of think, what I found best was to have an excel sheet with the same headers as your table and just export it into the excel sheet.Sorry to be a little dim, what is the reason for exporting to excel, as you should be able to do all the things you need via access.

[akrylik]

We have to use excel for reporting to our superiors. Is there no way to export individual values at the time of the calculations in a real time scenario.

[tanvi]

You can use TransferSpreadsheet to get data into Excel unless you need something more than it allows. For more information check this link:http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

If you want more than a basic datagrid then you should open that file using Excel automation. For more information check this link:http://support.microsoft.com/kb/247412

Also check this article; it has more sufficient information about Export data to Excel:http://office.microsoft.com/en-us/ac...001224122.aspx