deleted records in DBF files
 

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

deleted records in DBF files
 

"Stefi" wrote in message
...
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


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