How to export a query into Excel?

[Juleee]

Dear all,

I need to export the results from MS Access into Excel file into 3 different worksheets (A, B and C).

While exporting, the Excel file should have a column that includes hyperlink with one fixed part (link to a website) and one variable part (cell in Excel workbook) of the outcome.

Is there a way to do this with Ms Access VBA?

Thanks a lot for your help.

 

[ranman256]

vFile = "c:\myfolder\file.xlsx"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, vQry1, vFile, True, "sheet1"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, vQry2, vFile, True, "sheet2"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, vQry3, vFile, True, "sheet3"

 

[Juleee]

Thank you very much.

Another thing I need to do is the following:

1. I need the code to export MS Access data into Excel file
2. While exporting it has to create an additional column in Excel file (SQL based)
3. This column should include the link to the website (which always stays the same) and reference to the excel cell (B2, C2, D2, E2 etc.)
4. The additional column should have special formatting, i.e. text written in red and in Italic.

Is here a way to do this with VBA?

Thanks a lot for your help.