🧚 Listen! Beekeeper Studio is a fast, modern, and open source SQL Server GUI Download
March 15, 2023 By Beekeeper Studio Staff

You want to import your sales orders from a comma delimited file into a SQL Server or MSDE table called orders. The file looks like this:

345,John Doe, 400
346,Mark Smith,450
347,Robert,400

Run the following SQL command in Beekeeper Studio, SQL Server Management Studio, or any SQL client. Replace lower case text with your own:

BULK INSERT [orders]
FROM 'c:orders.csv'
WITH (FIELDTERMINATOR = ',')

Result (order table):

OrderID Name Price
345 John Doe 400
346 Mark Smith 450
347 Robert 400

Make sure the field terminator (‘,’) in this example is not part of any actual value. The field Name for instance cannot be ‘Doe, John’ since the ‘,’ would be considered as a field terminator.

The table has to be similar in format to the file (same number of fields and same data type.)

If your values contain commas, or the CSV isn’t on the database server, paste it into our CSV to SQL converter instead. It handles quoted values and writes INSERT statements, plus a matching CREATE TABLE, that you can run from any client.

Beekeeper Studio Is A Free & Open Source SQL Server GUI

I’ve upgraded from SQL Server and it was a smooth change — Beekeeper Studio enhanced my own workstream, offering a cleaner experience and better performance, as well as flexibility. - Aman Bhattarai

Beekeeper Studio is a fast, intuitive and easy to use SQL Server client. It supports loads of other databases too, and works great on Windows, Mac and Linux.

Beekeeper's Linux version is 100% full-featured, no cut corners, no feature compromises.

What SQL Server Users Say About Beekeeper Studio

Mark Koops

So far the most comprehensive DB admin GUI out there. The only reason I haven’t given 5 stars is I cannot claim to have used it exhaustively only having discovered it two weeks ago. But so far, mySQL, MSSQL and Postgres in one tool is simply incredible.
Planning to purchase once pay day hits.

Neal

I had been using the free version of Beekeeper studio for a while, but when I needed to work with some MongoDB databases I upgraded to the paid version. And honestly, I was up and running in no time. Beekeeper is slick, fast, and it just works. Very intuitive, very easy to use. I work with MongoDB, Postgresql, SQL Server, and other databases in my job, and having one tool that can talk to them all is just wonderful.
Thank you, Matthew and team!

Ready to Improve Your SQL Server Workflow?

download Download Free