I have 4 large (column delimited) text files to import every two weeks. The import wizard works great but I have to manually start each of the files and I would like to automate the process. Does anyone know how to do such an import programmatically...ie....here's filename.ext, import x number of columns at these specific column locations...?

The only other option I've come up with would be to add some more VB code to the program that prepares these several MB text files out of one 70MB text file, so that it makes some type of general database structure that can be imported more easily into the four VFP tables I want to end the process having.

Thanks,

Doug Symes
IT Technician
InterConnect Wiring,LP.