how to import csv file into table of sql server other than BUIK INSERT

Question

I googled the solution online and most of the result comes back with BULK INSERT, I don't have the access to this role at this point so this is not an option.

Is there any other generic way to import .csv file into MS SQL SERVER?

score 0 · Answer 1 · answered Mar 09 '14 at 05:25

0

I believe you need to use either SSIS or bcp if you don't have bulk insert rights. Although I would be open to learning another way.

answered Mar 09 '14 at 05:25

attila

2,219
1
11
15

score 0 · Answer 2 · edited May 23 '17 at 12:28

0

Solution I've done the last few times I've needed to do this was save the CSVs as .XLS in excel and then pull it in from SSMS.

Edit: Here's a SO answer that shows how to do it

edited May 23 '17 at 12:28

Community

1
1

answered Mar 09 '14 at 16:03

safetyOtter

1,430
14
26

score 0 · Accepted Answer · answered Mar 18 '14 at 20:41

0

what I end up doing is go to task--->import, this is the original DTS functionality and it does give me option to import excel file.

answered Mar 18 '14 at 20:41

user3306308

45
6

how to import csv file into table of sql server other than BUIK INSERT

3 Answers3