export sql server 2005 to dbf

145 pts.
Tags:
SQL Server 2005
I have problem with exporting a table to a dbf format file in sql server 2005 Has anyone done it before? Thanks!

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hello,

Good place to look for all your answers on SQL Server 2005.

Hope this helps…

TPinky

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,280 pointsBadges:
    report
  • Mrsachinjain
    You can use microsoft VFPOLEDB provider to generate DBF files from SQL server. However, this will only work on 32 BIT OS as there is no 64 BIT compatible VFPOLEDB provider from Microsoft. Use the Following Command to generate DBF: INSERT INTO OPENDataSource('vfpoledb','Data Source="D:DBFShareOUT"')...<DBF File NAME> (DBFCol1, DBFCol2, DBFCol3) Select SQLCol1, SQLCol2, SQLCol3 FROM SQLServerTABLE
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following