insert multiple rows into MSSQL from csv file
Posted on 2010-11-10
Hi, I'm using MS SQL server management studio express. I have a table that looks like this:
ID, cust_name, cust_email, cust, cust_bday, cust_aniversary
I also have a csv file which only contains a list of email addresses, it looks like this:
I would like to get these into the database and only need them to go into the cust_email column, the other columns can be blank (of course id will auto populate).
What is the best way to do this? Thanks.