Hello,

Is there anyway that i can export specific data from Access 97 into Excel 2000 from an asp web page?

Here is the senario:

The user choses what they want to export from Access from a set of drop down menus on the asp page. On clicking on a submit button, the relevant data is extracted from the database and inserted into an Excel spreasheet.

Is this possible?

Any help is much appreciated.

Thanks in advance.

Using the OLEDBDataAdapter object, you import the data into a data set from Access 97, and specify the OLEDBDataAdapter to update the Excel. How you do this is using the DataAdapter.Update() statement, which updates the data source in Excel. Now, you have to do mappings to connect the dataset to the new data source. Take a look at the Update statement in the MSDN, as well as the OLEDBDataAdapter.

Brian