Skip to Content
May 01, 2010 at 06:42 AM

Extracting data from Foxpro database/dbf files



I need to pull data from FoxPro database system. I'm having problems filtering by date. Can someone please let me know if they have found a work around.

Foxpro likes the date to be entered in { } and preferably american format, so you would say

date >= {01/01/2010}

However the DI tool does not like it when this format {01/01/2010}, then if you put it as '{01/01/2010}' it then thinks you are passing a paramater value.

Any ideas?

Thanks in advance 😉