Copy external data structure to new table 
Author Message
 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?



Mon, 15 Jan 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Copying the structure of a table to a new table

2. Copying the structure of one Access table to a new Access table

3. HowTo Copy a Recordset from a Table to an identically structured table

4. How to copy a data control recordset to a new table

5. Copy Data Structures no data DB to DB

6. copy data structure and data

7. Copying table definition to create new table

8. copy mdb base structure to new one from vb6

9. copy table structure

10. Copying table structures in code

11. Newbie: How to copy Table structure?

12. Copy Foxpro 2.6 table structure

 

 
Powered by phpBB® Forum Software