Discussion Locked

Database conversion

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I made a data entry program in Visual Basic using a MS ACCESS database. How am I going to convert this MS ACCESS database to an EXCEL format file to be accessible to a third-party software. I will highly appreciate immediate response. Thanks.

6 replies

by fromnaija

Can you throw more light on your question. Are you thinking of converting the Access database to Excel outside of your VB app or do you want to export some of the data from the database to Excel format from within your VB app?

by jbelina

If you are looking to convert your access tables to excel you can use the following for each table in your database:

'test is the name of my input table and the next parameter after that is the location of the excel spreadsheet I'm exporting to...

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97 , "test","C:\test\jbelina.xls"

Hope this helps!
Jeff

This discussion is closed to new replies.