I'm going out on a limb here since I haven't done much with automation. But it seems like there should be some way to automate the save function. Try running a macro and save as a DBF. Then look at the code it generates. You should be able to do that from VFP using automation.

Michelle


>You mean to do 'save as' command in Excel? I have to use this import routine every month. I don't want the user do anything manually but running this program. I am looking for something that can handle everything in vfp.
>Thanks Michelle.
>sherry