• Home
 · 
• Custom Controls/Forms/Menus
 · 
• Here's how you can export data from a DBASE IV platform to an excel file format using Visual Basic

Here's how you can export data from a DBASE IV platform to an excel file format using Visual Basic

Here's how you can export data from a DBASE IV platform to an excel file format using Visual Basic 6.0 development tool. I havent tried other

Rate Here's how you can export data from a DBASE IV platform to an excel file format using Visual Basic

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

' pass QUERY to strQry variable

With mconExcelConnection
        If .State = 1 Then .Close
        .CursorLocation = adUseClient
        .ConnectionString = "Driver:DBASE IV;Extended Properties=Excel 8.0"
        .Open
    End With

or 

With mconExcelConnection
        Dim recset as new ADODB.Recordset
        .ConnectionString = "Driver:DBASE IV;Extended Properties=Excel 8.0"
        .Open
        set recset.ActiveConnection = mconExcelConnection	
        recset.open strQuery	
    End With