Subject Re: importing csv file From Mustansir Ghor <mustan31@hotmail.com> Date Wed, 30 Jun 2021 04:39:27 -0400 Newsgroups dbase.getting-started Attachment(s) ghor.csv Dear Gaetano I am sending csv file that need to be appended Thank You Regards mustansir Gaetano D. Wrote: > On 30/06/2021 03:33, Mustansir Ghor wrote: > > 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. > >> > >> > >> > Hi Mustansir, > > Can you show us a sample record in CSV format so we can see what you are > working with in terms of date format and delimiters? > > Replace sensitive/personal data with dummy data if needed, but leave the > format unchanged (date separators, field separators and field delimiters). > > If the source date format is something like \"2021-01-01\", you will need > to remove the separators before you append the data. If your input is > format as \"2021-01-01 09:00:00\" as you might expect in an access control > system, then you need a timestamp field and the separator needs to be > removed too else it won\'t append or will append incorrectly. > > -- > Gaetano. >