Welcome to Sign in | Help

Re: Import .dbf in SQL Server 2005

  •  11-27-2006, 5:21 PM

    Re: Import .dbf in SQL Server 2005

    ""
    Exista mai multe optiuni de a obtine datele dintr-un dbf printre care:

    1. Definiti un linked server si interogati direct datele din DBF.

     fisierul .dbf este pe Desktop de ex. .... ce link server sa fak ? 

    2. Folosind SQL Server Integration Services.

     nu reusesc ..... ce dau la data sources-> provider dak fisierul se afla pe desktop ?? 

    3. Folosind OPENROWSET

    SELECT * FROM OPENROWSET(
       'MSDASQL', == 'SQL2005' (serverul meu de SQL) => Msg 7403, Level 16, State 1, Line 2
    The OLE DB provider "SQL2005" has not been registered.


       'Driver={Microsoft dBase Driver (*.dbf)};DBQ=C:\MyDbfFiles\',
       'Select * from MyTableName')  
    ""
     

     Spune mi te rog unde gresesc ... merci mult !!

     

      Pana la urma am fakut o magarie . Am down un programel care face conversie .dbf2.xls si apoi import in SQL !!  .... ideea e ca dak ma duk la clinet nu pot sa ma apuk de instalat programele si atunci ce fak ??

     
    Merci !
     


    MCSE;MCITP
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems