Subject Re: modify table structure in program From Ken Mayer <dbase@nospam.goldenstag.net> Date Sat, 5 Mar 2022 14:20:31 -0800 Newsgroups dbase.getting-started On 3/5/2022 2:15 PM, Charlie wrote: > Hi...   I am importing a csv file by 'save as' a dbase table.  But I only have four fields in the csv file and I need to modify the table before opening the form with grid which specifies more fields.  As I understand 'save as' overwrites the table losing all structure.  Wondering if there is a way to add and modify fields using a program rather than manually modifying the structure? You would need to use SQL: alter table Check help. Ken -- *Ken Mayer* Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm