(As much as I hate admitting knowledge of FoxPro...)  FP has a native
command for doing this--search the help file for the APPEND FROM command.
That's probably easiest if you've got FP or VFP.

HTH,

-Roy

-----Original Message-----
From: Rick Delorme [mailto:rickd@c...]
Sent: Thursday, May 31, 2001 7:14 AM
To: professional vb
Subject: [pro_vb] Importing comma delimited data


Hi all,

I am trying to figure out how to import a file delimeted file in order to
append it to a database table (fox pro). If any one out there knows anything
about how this can be done, your input would be greatly appreciated.

Here is a sample of the data. This would convert to 6 records:

,11743320,"BAR STOCK, 3 1/2"" DIA. ",$39.61
3004179,,CARRIER-SEAL,
,11761480,"BAR STOCK, 1.75"" DIA.",$9.69
3005290CLA,,WEIGHT-BALANCE COMP,
,56244003,"TUBING, 4.00"" OD X .5625""WALL",$112.92
3005290CLB,,WEIGHT-BALANCE COMP,

Thanks.


--
Rick Delorme
Software Developer
C-Team Systems Inc.
11-38 Auriga Drive
http://www.cteam.ca
http://www.rickdelorme.com