In Access we can export an .mdb table to .xls format with this code:
DoCmd.OutputTo acOutputTable, "Table1", "MicrosoftExcel(*.xls)", "\MyTable\" & "WorkSheet1.xls"
I want to do the same thing using VB6 but don't know how? Please guide me on how to do the stuff thanx!
DoCmd.OutputTo acOutputTable, "Table1", "MicrosoftExcel(*.xls)", "\MyTable\" & "WorkSheet1.xls"
I want to do the same thing using VB6 but don't know how? Please guide me on how to do the stuff thanx!