How to access Visual Foxpro(.DBF) file in SQL Server 2000

• ANR-352545

  Grasshopper

  Points: 22

  More actions

  July 20, 2008 at 3:07 am

  #75265

  Dear All,

  I have DBF file of Visual Foxpro. File is created at every month in Visual Foxpro base application. I want to open/access it in SQL Server 2000 for REPORT purpose. How it possible through Script or ODBC ? After that I want to develop report coding in SQL.

  Please give me guidance.

  Thanks in ADVANCE.

  -ANR

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  July 20, 2008 at 12:00 pm

  #845435

  Start your reading here:

  Data Transformation Services (SQL Server 2000)

  DTS Import/Export Wizard

  URL: http://msdn.microsoft.com/en-us/library/aa176528(SQL.80).aspx

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• Laurence Leveille

  Newbie

  Points: 3

  More actions

  August 14, 2008 at 12:04 pm

  #858290

  wow bitbucket .. I am sure he found your response very helpful.