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?

Thanks,

Ben Holton