Subject |
Re: csv import into dbf |
From |
Mervyn Bick <invalid@invalid.invalid> |
Date |
Tue, 20 Aug 2024 09:48:36 +0200 |
Newsgroups |
dbase.getting-started |
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.
|
|