Exporting to .xls and Opening a Form in a stored procedure

[allyne]

Hi Everyone,

I have a stored procedure that executes several other stored procedures. I need to add to this stored procedure a way to export a table to Excel and then open a form in a Access Project. For example:

I need to export tblTempNcm (table in Sql) to T:\NacnAudit\Audit.xls then

I need to open a Form in dbMasterReports (Access Project Database in T:\Reference Reports) the form is called frmAuditDuplicates.

I'm using SQL 7.0 as the back end and Access Project 2000 as the front end.

Is there a way to do this in a stored procedure? If so can you give me the correct syntax?

Can't seem to figure this one out.

Thanks For all you help!

Cathy