Exporting Access data to Excel

  • 14 years ago

    In an Access form I have a button to export data from a query to an Excel file:

    Dim objExcel As DAO.Recordset
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Req_ImportALlToExcel", "C:\File.xls"

    It creates an Excel file with the proper data.  My question is what to do to open it at the same time without exiting Access?



Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“A computer is a stupid machine with the ability to do incredibly smart things, while computer programmers are smart people with the ability to do incredibly stupid things. They are, in short, a perfect match” - Bill Bryson