export selected worksheet into dbf format

[prasadksu]

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.

[nirvana_1]

use macro recorder and alter the code for the transfer.