>I'm relatively new to VB, and I'm developing an application that populates two tables in an Access database. After the tables are populated, I need to export the tables to Excel spreadsheets.
>
>Does anyone know the best way to export an Access table to Excel using VB besides manually populating the cells using OLE Automation?

It is a lot faster to assign an array to a Excel Range.