Import a CSV into SQL Server database

Question

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Paul White SSC Guru Points: 150468 More actions · Answer 1

There are many ways to import such a file into SQL Server directly.

If you must use an external C# program for some reason, there are plenty of code examples out there.

A Google search for "C# CSV SQL Server" revealed one example:

If you tell us more about what you need to do, what version of SQL Server you are using, and so on, you'll get a more targeted answer.

steveb. SSC-Forever Points: 46733 More actions · Answer 2

You are probably better asking this question in a c# forum.

Here we will tell you to use Bulk Import or SSIS

shravan.322 Grasshopper Points: 18 More actions · Answer 3

Hello Paul ,

Thanks for the reply & the example suggested.

This really helped my purpose.

Thanks

Shravan