deleted records in DBF files

[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

 

[Cindy Winegarden]

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)?

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