Search code examples
databasestructuredbfvisual-foxpro

how to copy structure and data with specific column in visual foxpro

Please help, I have large database in DBF where have 34 column and more than 50k record. In this case, I need 10 column only from 34 column. Logically, if I delete not necessary column will reduce data load. So I will copy structure and data from source file with specific column, but I do not know how to do it in visual foxpro.

Will you help me for this case ?

Before and after, thanks for your attention to read my problem.

Regards,

Pathic

Solution

  • Use the following syntax:

    SELECT col1,col2,col3,col4,col5,col6,col7,col8,col9,col10 FROM table1 INTO TABLE table2