We help IT Professionals succeed at work.
Get Started

Import data from a csv file

508 Views
Last Modified: 2014-05-01
I need to import data from a csv file to a Vfp table called Laundry.  In the csv file, there are three data fields(Date, Total Weight, Description) to import into the vfp table.  I have the csv file attached below.  What code can I use to import the csv data?

Laundry table-fields                                  csv file-fields

Date----------------------------------------------05/01/2014
blktdescript-------------------------------------Blankets
blktamtin----------------------------------------Total Weight
shtpdescript------------------------------------Flat Sheets
shtpamtin---------------------------------------Total Weight
shtbtdescript------------------------------------Fit Sheets
shtbtamtin--------------------------------------Total Weight
sprddescript------------------------------------Spreads
sprdamtin---------------------------------------Total Weight
Btdescript---------------------------------------Bath Towels
Btamtin------------------------------------------Total Weight
Bstdescript-------------------------------------Bea Shop Towels
Bstamtin----------------------------------------Total Weight
Pcdescript--------------------------------------Pillow Cases
pcamtin-----------------------------------------Total Weight
Wcdescript-------------------------------------Wash Cloths
wcamtin----------------------------------------Total Weight
Oth21descript---------------------------------Personal Garment
oth21amtin------------------------------------Total Weight
1-2014-5-1-8-1.csv
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE