Subject Re: csv import into dbf
From Charlie <tm@tc.com>
Date Tue, 20 Aug 2024 07:48:32 -0400
Newsgroups dbase.getting-started

I slept on it and that was going to be the first thing I was going to try.  Thanks!!!

Mervyn Bick Wrote:

> On 2024/08/19 20:43, Charlie wrote:
> > Thanks for the help guys..  I am traveling so I'm behind.
> >
> > I am trying yours Mervyn.  Because i am using inno I have put your program directly in dbase not duflp.  Same with stringex.cc.  i am using a test program which is the following:
> >
> > set procedure to append_from_csv.prg
> > append_from_csv(':coindata:csvrec.dbf','csvrec.csv','a',true)
> >
> >
> > But when I run it I get an error message that file does not exist on line # 130.
> >
> > if I ignore the error it finishes but with no results.  I know the table (which is in my bde) is correct.  What am I doing wrong?
> >
>
>
> The program doesn't know what to do with the :coindata: BDE alias.  If
> the program is in the same folder as the .csv file and you use the
> actual path of the .dbf file instead of the alias it should work.
>
> append_from_csv('C:\the_actual_path\csvrec.dbf','csvrec.csv','a',true)
>
> Mervyn.
>
>
>