none
DBF to SQL

    Question

  • This is more of a question than a problem...

    I have a collection of DBF (FoxPro) tables that I need to search through to select only ones that contain certain column names. Then I need to combine selected tables into one (possibly eliminating duplicate records in the process) in SQL.

    This table will be updated/overwritten every day.

     

    What would be the cleanest way to implement this idea?

     

    Thank you

    Thursday, April 24, 2008 1:24 PM

All replies

  • SSIS is the tool for this job. ( if you have 2005)

     

    what version of SQL do you have ( help/about/cut/paste)

     

    Thursday, April 24, 2008 3:12 PM
  • Thank you for the response!

     

    Microsoft SQL Server Management Studio Express      9.00.3042.00
    Microsoft Data Access Components (MDAC)      2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
    Microsoft MSXML      2.6 3.0 4.0 5.0 6.0
    Microsoft Internet Explorer      7.0.5730.11
    Microsoft .NET Framework      2.0.50727.1433
    Operating System      5.1.2600
    Thursday, April 24, 2008 3:29 PM
  • You are 2005

    You are running express.

     

    (just checking are you running non-Express SQL on your server?)

     

     

     

    Thursday, April 24, 2008 3:38 PM
  • I'm running SQL Express... But I will be implementing it in SQL 2005 Server... I'm not familiar with SSIS but I will research on it.

    Thursday, April 24, 2008 5:01 PM
  •  

    Actually, if possible, I need to be able to establish connection between DBF and SQL server regardless of its version.
    Thursday, April 24, 2008 6:18 PM
  • the other option without SSIS is link a DBF as a linked server

     

    Or you could use a program to transform the data

     

    Thursday, April 24, 2008 7:42 PM
  •  

    Using linked server: is there a way to get names of all of the tables in the location that the server is linked to?

    Friday, April 25, 2008 12:53 PM
  • I don't think so from the linked server

     

    Code Snippet

    sp_addlinkedserver 'dbf', '', 'MSDASQL', 'dBase Files', Null, Null, 'C:\dbf Folder'

     

     

    however I knew the file/table names of files I wanted to import.
    Friday, April 25, 2008 1:13 PM