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
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Oct 18, 2015 | Microsoft Office Computers & Internet
Sep 03, 2010 | Microsoft Windows XP Media Center Edition...
are some reasons which may damage your MS access database such as
virus infection, software crash, accidental shutdown of system,
unrecognized format of database, corruption of storage media etc.
These issues are easy to overcome by using third party software of
access database repair.you can try Kernel Access Database Recovery Software one of the best software in Data Recovery
For information you can visit here ...http://www.accessrecoverytool.net
Aug 23, 2010 | Microsoft Computers & Internet
Mar 30, 2017 | Microsoft Computers & Internet
Mar 09, 2009 | Microsoft Press MS Access 2000 and Visual...
Feb 17, 2009 | Microsoft Visual Basic 6.0 for PC
Dec 11, 2008 | Microsoft Computers & Internet
Nov 10, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)
Sep 26, 2007 | Microsoft Office Standard for PC
Apr 26, 2017 | Microsoft Visual Basic Professional...
199 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: