Post reply

Converting text file to Visual Foxpro File Format

  • July 22, 2004 at 7:00 pm

    #161193

    Hi,

    Can any one guide me how to convert the text file to Visual Foxpro File Format using the DTS?

    Thanks!

    Kindest Regards,

    dorcas

  • July 26, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • July 26, 2004 at 10:44 am

    #516127

    I discovered over a year ago that either with the Export Wizard in EM or with a DTS package, you can export SQL data to Visual Fox Pro with the DBase iii/iv driver.

     

    Hope that helps.

    dab

  • July 26, 2004 at 6:32 pm

    #516182

    Hi Dab,

    Thanks for you information. But, what do you mean Dbase iii/iv driver? How to do that? Can you give me some more clues.

    Thanks!

    Kindest Regards,

    dorcas

  • July 27, 2004 at 6:45 am

    #516274

    Once you've created your package, you will need two connections, one for your SQL server and one for Dbase iii/iv. In the 'Connection' pane click the icons to create the SQL connection and the icon for 'Other Connection'. When you click the 'Other Connection' object make sure in the Data Source drop down that you've selected Dbase iii or Dbase iv. If you are creating a new db, then just select a path where you want the file stored. The DTS package will create it when it runs. Otherwise select the FoxPro .db file that you want to the data exported.

     

    dab

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

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