
Copy external data structure to new table
I am trying to convert old FoxPro 2.5 code in VB using FoxPro databases
and rdo.
I need to upload ASCII to tables. Since the structure of the ASCII sent
to me each month changes frequently, I was using an empty FoxPro table
to use as a structure, copying the structure and indexes to a new table,
and then appending the ASCII file. I would then need to delete certain
records such as those with no charges, group the totals, and pack the
database.
I was thinking of using this file structure to get rid of the deleted
records by setting deleted=on in the .ini and copying the records to a
new file. I can't find anything in VB that would copy just the
structure of the external database.
Does anyone know how I could do this? Is rdo the best method?