The Upsizing Wizard in Sedna is great for this. The UI and engine are separate, so you can figure out all the steps and write a program that calls the engine to do all the work for you.
>Hi folks, thanks for your reply.
>
>I am looking for an ongoing utility to import data, ratther than a once off
>This is for a .net app which will be taking data from a vfp/excel file on an ongoing basis... sometinkg lile appe from MyExcel type xls
>I will start another thread for this.
>
>Thanks again for your help.
>
>Regards,
>Gerard
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer