deleted records in DBF files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

When I open a DBF file in XL2003, deleted records are not imported. Is there
any way to import also them into Excel (without making them first undeleted)?

Thanks,
Stefi
 
Stefi said:
Hi All,

When I open a DBF file in XL2003, deleted records are not imported. Is
there
any way to import also them into Excel (without making them first
undeleted)?
Click to expand...


Hi Stefi,

You can configure the Deleted setting in your ODBC data source. However, the
rows would lose their deleted status and look just like undeleted rows. To
do this, click the Options>> button and clear the Deleted box. It's
counterintuitive in that checking the box corresponds to "Set Deleted On"
which is the FoxPro setting to hide deleted rows.

--
Cindy Winegarden
(e-mail address removed)

VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
 
Back
Top