Post reply

How can I connect my Foxpro for DOS database to my SQL Server?

  • May 19, 2005 at 11:53 pm

    #164630

    Hi!!!

    I am working on my SQL Server 2000. I want to use my Foxpro for DOS databases (dbf) but I dont know how. Is there anyone who can give me an idea on how could I connect them to the SQL Server?

    Thank you very much!!!

  • May 20, 2005 at 12:42 am

    #560103

    DTS is the best option for this




    My Blog: http://dineshasanka.spaces.live.com/

  • May 20, 2005 at 6:03 pm

    #560371

    Hi Dinesh,

    Im sori but what's DTS?

  • May 21, 2005 at 12:50 am

    #560379

    Ok. No problem it just mean you are new to SQL Server.

    In Brief DTS was the most biggest selling point for SQL Server 7.

    Go to Enterprise Manager --> SQL Server ---> Data Transformation Service -- > Local Package

    Right Click Local Pacakge and you can design the DTS over there. As you are new you may have some problems but it is never late to learn.

    Now if you need to import the foxpro database. Simply create a new database. right click on table and click on Import Data. Just complete all the screen (Wizard) and you will able to import the database from foxpro. You may have some problem with datatype . You might have to create a DSN. Note: Choose Foxpro from data source.

    try exploring the linked server also. I do not remember whether DOS foxpro database can be linked but it is worth giving a try

     

     

     

     

     

    Kindest Regards,

    Amit Lohia

Viewing 4 posts - 1 through 4 (of 4 total)

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