deleted records in DBF files

S

Stefi

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
 
C

Cindy Winegarden

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
[email protected]

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