prasadksu
04-01-2009, 10:38 PM
Hi all,
I was wondering if anybody knows a VBA code to export selected excel sheet to .dbf format. I know we can export a table into .dbf format in access using docmd.......following is the access code
DoCmd.TransferDatabase acExport, "dBase 5.0", countyDB_dir_path, acQuery, "sSWAT_TAB", "SSURGO.dbf"
your held would be greatly appreciated.
Thanks,
Prasad.
I was wondering if anybody knows a VBA code to export selected excel sheet to .dbf format. I know we can export a table into .dbf format in access using docmd.......following is the access code
DoCmd.TransferDatabase acExport, "dBase 5.0", countyDB_dir_path, acQuery, "sSWAT_TAB", "SSURGO.dbf"
your held would be greatly appreciated.
Thanks,
Prasad.