FOX PRO Database

  • How do I bring a FoxPRO 2.x database into SQL Server 2000?

  • There is no such thing as a FoxPro 2.x database - just a set of free tables. You will have to import each one individually using OpenQuery. The Visual FoxPro driver will work.

  • you can also import them using the Dbase 3/4/5 in DTS.

  • Thanks for the replies.  Turned out it was a dBase III file.

  • And just for the fun of it MS ACCESS can handle dBase III file import in to SQL Server 2000 very nicely

     


    * Noel

  • Yeah, so does the SQL Server Import as long as the dBase III file has a name that is less than 8 characters!

     

    Data has been copied into SQL Server - Success

     

    Thanks

    Steve

  • Good for you!


    * Noel

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply