Welcome to Sign in | Help

Re: Update tabela din fisier csv

  •  01-19-2010, 1:55 PM

    Re: Update tabela din fisier csv

    Acum ma chinui doar sa fac un select si nu vrea
    Am 2 variante
    SELECT * FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0',
    'Text;Database=D:\;',
    'SELECT * FROM ajutor.csv')
    AS source
    si
    SELECT * FROM OPENROWSET('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=D:\;',
    'select * from ajutor.csv') AS source

    Ambele dau eroare
    .... could not find the object 'ajutor.csv'. Make sure the object exists and that you spell its name and the path name correctly."
    desi fisierul e acolo.
    Sorin Sandu
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems