Post reply

FOX PRO Database

  • July 20, 2005 at 12:58 pm

    #90123

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

  • July 21, 2005 at 4:43 am

    #576019

    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.

  • July 21, 2005 at 5:59 am

    #576034

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

  • July 21, 2005 at 6:26 am

    #576041

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

  • July 21, 2005 at 9:48 am

    #576132

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

     


    * Noel

  • July 21, 2005 at 10:00 am

    #576138

    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

  • July 21, 2005 at 10:33 am

    #576153

    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