Subject Re: importing csv file From Mustansir Ghor <mustan31@hotmail.com> Date Tue, 29 Jun 2021 13:33:16 -0400 Newsgroups dbase.getting-started Dear Mervyn Sir I read your below remark on date but could not figured the code to add. Will you help me on this. That code will work with most .csv files.  If, however, you have to import dates you may need to add code to format the date before it gets saved to the .dbf file. Thank you sir Best Regards Mustansir Mervyn Bick Wrote: > On 2021/06/02 21:56, Mustansir Ghor wrote: > > Dear All > > > > Is there a way to import csv file into dbf table > > > > Best Regards to all > > > > Mustansir > > > > Importdata.wfm in the dUFLP will do this.  The form is, however, more > suited to once-off operations as it requires quite a bit of user input. >   Where .csv files with the same layouts need to be imported into a > table regularly I find it easier to create a separate program to do the > work. > > If you look in the program I posted for you yesterday (nhif2.prg) you > will see that it did exactly that.  The .csv file Excel made on my > computer used a semicolon as the separator.  You would need to change > the ; to a comma in the breakstring parameter to deal with a comma > separated file. > > That code will work with most .csv files.  If, however, you have to > import dates you may need to add code to format the date before it gets > saved to the .dbf file. > > Mervyn. > > >