I am looking for a VFP generic import and export tool. These is the problem I am trying to solve with this tool:

In my business environment, I receive free table and sometimes ASCII and Excel data files from my clients. We use these information to make sales for the client, and we have to send the sales data back in the same format and structure they sent them to us.

We receive different file strucure from the clients and it is not unusual to receive different structure from the same client. The problem is that we have to write custom program for each file we receive to track the client sales information and report.

My proposed solution is to have a standard table structure on my end, and map the field from my client to the equivalent field name on my table when I import their data. I will then do the opposite mapping when I export the data to their table.

Is there any tool in the market that does this type of data mapping? Do anyone have alternative solution to this type of problem? I will like a wizard type of solution that will show the two tables, and allow simple point and click to do the mapping.

I will appreciate any suggestion. You can e-mail me at ffadayom@blenkarn.com