Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XAR files do not get deleted all the time. | Excel Discussion (Misc queries) | |||
XAR files do not get deleted all the time. | Setting up and Configuration of Excel | |||
Deleted files | Excel Discussion (Misc queries) | |||
Excel keeps copying deleted files | Excel Discussion (Misc queries) | |||
is there anyway I can recover deleted excel files | Setting up and Configuration of Excel |