Converting text file to Visual Foxpro File Format

Question

Converting text file to Visual Foxpro File Format

dorcas

SSC Enthusiast

Points: 122
More actions
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

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

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

Scalability Doug SSCertifiable Points: 5351 More actions · Answer 1

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

dorcas SSC Enthusiast Points: 122 More actions · Answer 2

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

Scalability Doug SSCertifiable Points: 5351 More actions · Answer 3

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