Import from csv to dbf

Hi All,

Did anybdoy created a code that can import the specific fields from a CSV
file? I may need to deal with 8GB of csv files and I would rather import
fileds to several tables for normaliztion purpose as well.

Thanks,

Joe

GaryBrueggeman
Tue Jun 24 14:43:05 CDT 2008


See the IMPORT command.
"JoeP" wrote:

> Hi All,
>
> Did anybdoy created a code that can import the specific fields from a CSV
> file? I may need to deal with 8GB of csv files and I would rather import
> fileds to several tables for normaliztion purpose as well.
>
> Thanks,
>
> Joe
>
>
>

JoeP
Tue Jun 24 14:48:12 CDT 2008

Hi Gary,

The Import command does not have an option to choose fields.

Regards,

Joe

Dan
Tue Jun 24 15:31:01 CDT 2008

Have you tried the import wizard?

If that's close, you have the code for it in the TOOLS directory so you can
give it religion.

Dan

JoeP wrote:
> Hi All,
>
> Did anybdoy created a code that can import the specific fields from a
> CSV file? I may need to deal with 8GB of csv files and I would
> rather import fileds to several tables for normaliztion purpose as
> well.
> Thanks,
>
> Joe

Michael
Tue Jun 24 15:38:01 CDT 2008

Hi Joe.

If all the files have the same format, you may just ahve to loop through the
csv files line by line and write fields 3, 5, 7 & 9 or whatever the are to
your table(s).

Mike


"JoeP" wrote:

> Hi All,
>
> Did anybdoy created a code that can import the specific fields from a CSV
> file? I may need to deal with 8GB of csv files and I would rather import
> fileds to several tables for normaliztion purpose as well.
>
> Thanks,
>
> Joe
>
>
>

JoeP
Tue Jun 24 15:55:40 CDT 2008

There is a 2gb file limitation of a table so I can not import the entire csv
file.

JoeP
Tue Jun 24 16:00:30 CDT 2008

It does not work with CSV format and when copied it to XLS, and it does not
let me select fields.
Maybe only using low level functions.