Category: vba

  • Import large Excel file into SqlServer

    I have to import the list of NGO from Romania to SqlServer.  Before seeing my solution,please do it yourself: the file could be found at http://www.just.ro/registrul-national-ong/ and the name is Asociatii I have tried with SSMS – no luck ( text will be truncated,even when I put nvarchar(max)) The I tried with flat file from…