Solved

Import csv file data into VFP table

Posted on 2014-07-29
1
1,011 Views
Last Modified: 2014-08-19
I need to take the attached csv file data and store it in a VFP table called laundry2 with the following fields.

Laundry2 table

blktdescript  C  21
shtpdescript C  21
shtbtdescript C 21
sprddescript C 21
btdescript C 21
bstdescript C 21
pcdescript C 21
wcdescript C 21
othdescript C 21
blktamtin N 5
shtpamtin N 5
shtbtamtin N 5
sprdamtin N 5
btamtin N 5
bstamtin N 5
pcamtin N 5
wcamtin N 5
othamtin N 5
date D 8
building C 10
0
Comment
Question by:campbme
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 12

Accepted Solution

by:
Missus Miss_Sellaneus earned 500 total points
ID: 40227394
You can do that with the APPEND FROM command

APPEND FROM FileName  ?
        [ FIELDS FieldList ]
        [ FOR lCondition ]
        [ [ TYPE ] [ DELIMITED
          [ WITH Delimiter  WITH BLANK  WITH TAB
          [ WITH CHARACTER Separator ]
          DIF  FW2  MOD  PDOX  RPD  SDF
          SYLK  WK1  WK3  WKS  WR1  WRK  CSV  XLS
          XL5 [ SHEET SheetName ]  XL8 [ SHEET SheetName ] ] ]
        [ AS nCodePage ]
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question