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

  • Thread starter Thread starter Lynn
  • Start date Start date
L

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?
 
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"
 
Back
Top