Discussion Locked
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 ramtep
The question was auto-closed by TechRepublic
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
by ramtep
This question was auto closed due to inactivity
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending
0 helpful
1 reply
0 helpful
1 reply
0 helpful
1 reply
1 helpful
3 replies
Discussion Locked
What Makes a Business Website Effective in 2026
2 helpful
10 replies