Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Brad SanMarie
  Where is Brad SanMarie?
 
 California - United States
 Brad SanMarie
 To: Imran Khan
  Where is Imran Khan?
 Lahore
 Pakistan
 Imran Khan
 Tags
Subject: RE: Import Data from Excel
Thread ID: 268829 Message ID: 268844 # Views: 50 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, July 15, 2010 12:08:31 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

Hello Imram.

If you go the automation way, you can actually skip rows and columns with titles and start picking data from any row you want. You can even pick data from any cell (for example A10 only) instead of importing the contents of the entire worksheet.

Brad Sanmarie

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