http://sqlserver.ro/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/7985.aspxTue, 19 Jan 2010 12:11:18 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7985rsocol0http://sqlserver.ro/forums/thread/7985.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=7985Eu mă refeream la ceva de genul: <br /> <br />SELECT * FROM OPENROWSET(BULK 'c:\test.csv', FORMATFILE = 'c:\test.fmt') AS a; <br /> <br />Răzvanhttp://sqlserver.ro/forums/thread/7984.aspxTue, 19 Jan 2010 12:06:25 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7984Diana0http://sqlserver.ro/forums/thread/7984.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=7984Poti sa si importi csv-ul intr-un tabel si apoi sa folosesti UPDATE / MERGE. In functie de "datele problemei", procedura se poate si automatiza.http://sqlserver.ro/forums/thread/7983.aspxTue, 19 Jan 2010 11:55:44 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7983ssandu0http://sqlserver.ro/forums/thread/7983.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=7983Acum ma chinui doar sa fac un select si nu vrea <br />Am 2 variante <br />SELECT * FROM OPENROWSET('MICROSOFT.JET.OLEDB.4.0', <br />'Text;Database=D:\;', <br />'SELECT * FROM ajutor.csv') <br />AS source <br />si <br />SELECT * FROM OPENROWSET('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=D:\;', <br />'select * from ajutor.csv') AS source <br /> <br />Ambele dau eroare <br />.... could not find the object 'ajutor.csv'. Make sure the object exists and that you spell its name and the path name correctly." <br />desi fisierul e acolo.http://sqlserver.ro/forums/thread/7982.aspxTue, 19 Jan 2010 11:13:56 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7982rsocol0http://sqlserver.ro/forums/thread/7982.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=7982Dacă foloseşti SQL Server 2005 (sau ulterior), poţi să citeşti datele dintr-un fişier CSV cu <a href="http://msdn.microsoft.com/en-us/library/ms190312.aspx">OPENROWSET</a>. Singura chestie este că &#238;ţi trebuie un <a href="http://msdn.microsoft.com/en-us/library/ms178129.aspx">format file</a>, pe care poţi să-l faci <a href="http://msdn.microsoft.com/en-us/library/ms191516.aspx">de m&#226;nă sau cu BCP-ul</a>. <br /> <br />Răzvanhttp://sqlserver.ro/forums/thread/7981.aspxTue, 19 Jan 2010 10:33:18 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7981ssandu0http://sqlserver.ro/forums/thread/7981.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=7981Cum pot face update la o tabela dintr-un fisier csv folosind TSQL ?<br>