OLEDB Newbie - how to ignore deleted rows?

Hi,

I am importing data from FoxPro 8 tables into SQL Server 2005, using the Microsoft OLEDB driver for Visual FoxPro 8. The development environment is VS2005, but that does not matter, it is the OLEDB component behaviour I need to understand.

My question is this:
Can I set it to ignore deleted rows when I ask the component to return a whole table? If I use a SQL Statement like SELECT * FROM tblFoxData then I get the correct rows. If I connect using the table name in the component, then I get the deleted rows as well, with no way then of ignoring them.
I would prefer to use the non-SQL route, as tests are showing it is faster, and my tables are >5 million rows each.

Sorry to trouble you all, but having scanned the help, and MSDN and googled everywhere I still can't find the answer to this one.

Thanks in advance,

Richard R.
.

Relevant Pages

  • [NT] FoxPro ODBC Driver Buffer Overflow via SQL OpenDataSource()
    ... OpenDataSource function in Microsoft SQL Server when we are connecting to ... "Microsoft Visual FoxPro Driver". ... we can overwrite EIP register with any value. ... SELECT * FROM OpenDataSource('MSDASQL','Driver=Microsoft Visual FoxPro ...
    (Securiteam)
  • RE: Update Conflict
    ... Microsoft SQL Server 7.0 or later versions and in Visual FoxPro ... record which has the update conflict issue, ...
    (microsoft.public.fox.helpwanted)
  • Freelance ASP.NET Programmer Looking for work
    ... SQL Server ... Windows API ... Web Services and Windows Services ... Visual Foxpro / Foxpro ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: [Error]Import data from vfp to sql server !
    ... Upsizing Wizard to convert the tables into SQL Server. ... If you are running VFP 7.0, you may want to get the updated Upsizing Wizard ... Keep an eye on the product lifecycle for Visual FoxPro here: ...
    (microsoft.public.fox.programmer.exchange)
  • Re: 2 newbie FP questions
    ... Roy Anderson wrote: ... > I wish to update the legacy progs, ... VB and SQL Server have never "replaced" FoxPro and Visual FoxPro in any ... Server or Visual FoxPro ...
    (microsoft.public.fox.programmer.exchange)