VBA to create auto Export data from Access 2002 to Excel 2002

[Lynn]

hi,

anyone know where i can find info or know how to automate
an export of data from an Access 2002 database to an
Excel spreadsheet?

 

[Chris]

Some sample code...

Dim x As Excel.Application
Dim ws As Excel.Worksheet
Dim wb As Excel.Workbook


Set x = New Excel.Application
Set wb = x.Workbooks.Open("path and file name")
Set ws = wb.Worksheets("Sheet1")

ws.Select
ws.Cells(1, 1) = "Sample text"