I am in the midst of writing an import wizard that allows for naming columns from a list of valid column names with default types, widths, and precisions.

It works a lot like the VFP import wizard in the sense that it intiates a different sequence of events depending on the type of file.

It supports Excel, Access, Dbf, Fixed, Delimited, and XML. The most difficutl was Fixed because we needed to find a way to drop lines on top of a representation of the data in an edit box. The solution was to put a transparent container on top of the edit box and "addobject" the lines to the edit box at the point of a click on a ruler bar above. The edit box can be panned left and right to allow you to see long records. When the edit box goes left and right so does the transparent container object (with the boundary lines) and so does the ruler line.

Choosing field names and types is a second-to-last page of a tab-less page frame. Not sure if the guy contracting this software would allow me to share it, but I can send you a whitepaper that I wrote.


>I am looking for a utility program of sorts. I would like to be able to take a source table in various formats (excel, lotus, etc...) and import data into an established foxpro table. Allowing for some field mapping and manipulation in between.
>
>This is different from just the import wizard. THe import wizard creates a new table. I want it to adjust the data to fit into an existing table.
>
>Any ideas?