Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Thomas Peirson-Webber
  Where is Thomas Peirson-Webber?
 London
 United Kingdom
 Thomas Peirson-Webber
 To: Imran Khan
  Where is Imran Khan?
 Lahore
 Pakistan
 Imran Khan
 Tags
Subject: RE: Import Data from Excel
Thread ID: 268829 Message ID: 269077 # Views: 31 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Friday, July 16, 2010 10:33:55 AM         
   


> Dear Experts,
>
> I have following data on Excel which I want to import into DBF. But Problem is occurs when I import data in Excel highlighted heading also imported with Data "See Image".
>
>
>
>
> Kindly suggest me how can do it.
>
> Regards
> Imran


Imran,

I would save the file in excel in CSV format and then in Foxpro:

APPEND FROM c:\filename TYPE csv

As it is a CSV file it will ignore the file line of the file (the headers).

Tom

ENTIRE THREAD

Import Data from Excel Posted by Imran Khan @ 7/14/2010 9:32:42 PM
RE: Import Data from Excel Posted by Anders Altberg @ 7/14/2010 10:26:37 PM
RE: Import Data from Excel Posted by Imran Khan @ 7/15/2010 11:22:20 AM
RE: Import Data from Excel Posted by Anders Altberg @ 7/15/2010 3:19:27 PM
RE: Import Data from Excel Posted by Imran Khan @ 7/16/2010 8:49:20 PM
RE: Import Data from Excel Posted by Tai Nguyen @ 7/14/2010 10:28:11 PM
RE: Import Data from Excel Posted by Brad SanMarie @ 7/15/2010 12:08:31 AM
RE: Import Data from Excel Posted by Thomas Peirson-Webber @ 7/16/2010 10:33:55 AM