May 2009

The Archives

• Microsoft, SQL

  Import CSV data into Microsoft SQL 2005 using bulk insert

  05.15.09 | Permalink | 2 Comments

  A little problem I had recently was to import a CSV file with about 16mb of data, into a Microsoft SQL 2005 database, using Microsoft SQL Studio Express. A csv file is a file with data that has “comma seperated values” (CSV) and by using SQL bulk load we can read this file from disk [...]

• Microsoft, SQL

  You do not have permission to use the bulk load statement

  05.09.09 | Permalink | 1 Comment

  I had a problem when trying to bulk load a CSV file into my Microsoft SQL 2005 database. The error was “You do not have permission to use the bulk load statement”. It turned out to be quite a simple solution.
  The solution: It was simply a permission issue and your SQL login needs to be [...]

Fusion Team Blog