Welcome to Sign in | Help

Re: Import .dbf in SQL Server 2005

  •  11-27-2006, 6:10 PM

    Re: Import .dbf in SQL Server 2005

    Am descarcat primul fiser dbf gasit cu google pe net si l-am pus in folder-ul C:\Temp\DBFFolder.

    Am reusit sa vad continutul unui tabel cu urmatoarea comanda:

    SELECT * FROM OPENROWSET(
       'MSDASQL',
       'Driver={Microsoft dBase Driver (*.dbf)};DBQ=C:\TEMP\DBFFolder\',
       'SELECT * FROM FREE);

     Unde FREE era numele tabelului.


    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems