>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.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com