I tend to code these by hand using FOPEN, FGETS, etc. Often, I do some data transformations as I'm importing. True, you could call it "grunt work" but somehow I've enjoyed writing these programs that "breathe in" data. Also, they typically run very fast.
There are tools that have been built for data import and transformation. Some of them may assign default data types where the data type is not pre-defined. I once spent some time with one called Data Junction. The DTS functionality in SQL Server could be used to import into a SQL database. There's probably many more tools out there. I'm not aware that anyone has ever built a generic text importer for VFP. I'm sorry that I'm not able to help with the specific issue of turning the interactive wizard into a batch import tool. However, I know the feeling of wanting an interactive tool to run in batch.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only