Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: newbie newbie
  Where is newbie newbie?
 jakarta
 Indonesia
 newbie newbie
 Tags
Subject: RE: converting date xls to dbf
Thread ID: 230092 Message ID: 230140 # Views: 34 # Ratings: 1
Version: Visual FoxPro 7 Category: Windows Vista and VFP
Date: Wednesday, June 03, 2009 12:33:57 PM         
   


> hi all,
> i have problem in importing excel to dbf format using VFP 7.0. I use APPEND FROM excel file TYPE XL8, and i store to new dbf table that has same order and data type with xls,some of date from year 2001 become blank in my dbf table. any idea? Thank You...



Could you check back in Excel if that particular date has been entered as a text string instad of as a date. Dates in Excel or acually stored as the number days since 1899/12/30. If you change the cell's formatting to Number it shouldn't show up as 0.
-Anders



COMPLETE THREAD
<ask>converting date xls to dbf Posted by newbie newbie @ 6/3/2009 7:16:30 AM
RE: <ask>converting date xls to dbf Posted by Anders Altberg @ 6/3/2009 12:33:57 PM