Foxpro

Forums › Microsoft Windows › Foxpro

pando

235 posts

Master Geek

#13676 23-May-2007 10:14

For a start, does anyone remember this or use it???

I used this back in the late 90's and it was my first database experience. I haven't touched it yet alone seen it in almost a decade now so I was mildly bemused when I was asked if I wanted to port a Foxpro database to SQL on the side.

So i'm thinking I will do this, however, does anyone know how to port the data or got any ideas on how to because from memory it's not SQL-92 compliant but then I can't remember as it's so long ago now...could I import data into excel through ODBC?

Thoughts?

freitasm

BDFL - Memuneh
80805 posts

Uber Geek
+1 received by user: 41408

Administrator

ID Verified

Trusted

Geekzone

Lifetime subscriber

#71837 23-May-2007 10:23

Are you porting to Microsoft SQL? If so I think you can import directly, there are drivers (Data Transformation Services) that are automatically installed for you in the Enterprise Manager (SQL Server 2000) although I can't see one in the Import Wizard (Microsoft SQL Server Management Studio 2005).

Referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies

Support Geekzone by subscribing (browse ads-free), or making a one-off or recurring donation through PressPatron.

pando

235 posts

Master Geek

#71840 23-May-2007 10:27

I don't have that information yet as I was in a pub half cut and promising the world haha

Guessing I just need assurance that FoxPro isn't so obsolete that there are tools for exporting the data out in a usable fashion and if so what they are.

rwales

122 posts

Master Geek

#72155 25-May-2007 07:03

Guessing I just need assurance that FoxPro isn't so obsolete

Nooo...FoxPro isn't obsolete! Apparently, you can still get Visual FoxPro 9 to 'create and manage high-performance, 32-bit database applications and components' (!) - see http://msdn2.microsoft.com/en-us/vfoxpro/default.aspx. Amazingly, there's even a Visual FoxPro toolkit for .NET.

I have vague (and painful) memories of FoxPro. However, there's a 'Visual FoxPro' ODBC driver on XP (MDAC 2.81.1117.0) which I assume could be used to export the data to a modern DBMS. Of course, if your data is pre-Visual FoxPro i.e. FoxPro 2 or something, you could have problems.

All your base are belong to us.

kiwiscanfly

3 posts

Wannabe Geek
Inactive user

#72817 30-May-2007 12:22

My boss uses foxpro and I recently had to write a dll so that he could easily access a .NET web service, I found that Rick Strahl of www.west-wind.com is the guru of foxpro. This article on integrating .NET with foxpro was really useful.