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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement