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