Hi scooper, thank you for repling to my query. However if it is as simple as
recording the macro and create it myself, I would not have to post the
question. Probably I was not clear in my first posting.

When an excel file is saved to .dbf file, the structure of the dbf file
needs correction. For eg, I may have to change the format for a particular
field to numeric and with 3 decimal places.

What I need is an excel macro that can copy excel worksheet into .dbf file
and at the same time change the structure of the .dbf file.

Hope there is some expert out there who can help.

Cheers

"scooper" wrote:

Can't you just "Save As" to a .dbf file?
If so start a macro record and create the macro yourself.
scooper