Question about Microsoft Visual Basic Professional Edition 6.0 for PC
Ive made an apllication that write my database into ms access.btw im using vb6 and ms access.below are my code that write db into ms access.but i want to change that into ms excel format.can anyone help please
Private Sub Command1_Click() BkpUpFileName = "" + Me.txtBkUpDest.Text + "\" + Me.txtBkpUpFName.Text + ".xls" Set FSO = CreateObject("Scripting.FileSystemObject") FSO.copyfile App.Path & "\Library.mdb", BkpUpFileName Me.Drive1.SetFocus ProgressBar1.Visible = True Timer1.Enabled = True
Your code does not save in access format it just makes a copy of existing file. You need to open table by table and export data using csv format.
It can be done using access OLE to export, or
write some VB code to access the database tables via ODBC and save row data to csv file
Posted on Feb 17, 2009
Tips for a great answer:
May 12, 2014 | Microsoft Database Software A5K-02817 SQL...
Mar 05, 2011 | Microsoft Compilers & Programming Tools
May 31, 2010 | Microsoft Visual FoxPro Professional...
Jun 16, 2009 | Microsoft Visual Basic Enterprise Edition...
May 14, 2009 | Microsoft Visual Basic Professional...
May 12, 2009 | Microsoft Visual Basic Enterprise Edition...
Mar 31, 2009 | Compilers & Programming Tools
Mar 02, 2009 | Microsoft Visual Basic 6.0 for PC
Feb 17, 2009 | Microsoft Visual Basic 6.0 for PC
195 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: