Wrox Programmer Forums
|
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 27th, 2004, 04:41 AM
Friend of Wrox
  
Join Date: Jul 2004
Posts: 345
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to gokul_blr Send a message via Yahoo to gokul_blr
Default SQL to DBF
Can anyone tell SQL DTS / Import creates Dbf?




Gokulan Ethiraj
__________________
Gokulan E
 
Old September 27th, 2004, 04:49 PM
Friend of Wrox
  
Join Date: Jun 2003
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Default
The last time I did that, I found it was easier to export SQL to Access and then Access to .DBF.

Rand
 
Old September 28th, 2004, 01:10 AM
Friend of Wrox
  
Join Date: Jul 2004
Posts: 345
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to gokul_blr Send a message via Yahoo to gokul_blr
Default
One step extra,

Can we automate the same to get the dbf's as the final output.
and by ignoring the mdb's.




Gokulan Ethiraj
 
Old May 16th, 2006, 01:04 AM
Registered User
  
Join Date: May 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to harriet
Default
hi! i have the same problem. have u ever found a way to automate converting sql data (in tables) to dbf file? pls pls let me know how.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Fetch data from DBF to SQL arty125 VB.NET 1 August 20th, 2007 01:06 PM
Transfer data from .dbf file to SQL Server 2000 somnath.kartic SQL Server 2000 1 October 18th, 2006 11:01 AM
SQL table to .DBF file harriet SQL Server 2005 1 May 17th, 2006 06:37 AM
dbf to sql conversion marck SQL Server 2000 1 November 13th, 2003 02:37 AM
DBF Database phil_kenney VB Databases Basics 0 June 16th, 2003 12:27 PM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.