vb to Excel

[galadriel]

Does anyone know how to send the contents of a database to Excel from vb?

Thanks much

[Clunietp]

Do you have an existing XL sheet this must go into?

Is this from MS Access to MS Excel?

[galadriel]

I am using vb6 to open a small user info and inventory MS Access 2000 database. At certain times, I need to export all of the data to MS Excel 2000 so it can be read at a different location. It needs to be exported from Access to a new Excel spreadsheet using Visual Basic 6.

Thanks

[JHausmann]

In Access help, do a search on "TransferSpreadsheet".