Read .csv file and write in a table

Ram Subramoni answered on June 22, 2020 Popularity 9/10 Helpfulness 1/10

answer Read .csv file and write in a table

related Write a table to CSV file python

Read .csv file and write in a table

Comment

-1

if OBJECT_ID('tempdb..#tmp') is not null drop table #tmp
 create table #tmp
   (
	 ID nvarchar(100),
	 Name nvarchar(100)
   )
BULK INSERT #tmp FROM 'D:\names.csv'
  WITH 
    (
	  FIELDTERMINATOR = ',',
	  ROWTERMINATOR = '\n',
	  TABLOCK
	)
GO
 select * from #tmp

Popularity 9/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: file sql

Link to this answer
Share Copy Link

Contributed on Nov 01 2023

Ram Subramoni

0 Answers Avg Quality 2/10

Closely Related Answers

Write a table to CSV file python

Comment

header = [re.sub(' +',' ',i[0][:-1].replace('\n', ' ')) for i in optionsTable[0]]

with open('test.csv', 'w') as fp:
   writer = csv.writer(fp, delimiter=',')
   writer.writerow(header)
   for row in optionsTable:
      writer.writerow([i[1] for i in row])

#Credit to https://stackoverflow.com/users/790387/burhan-khalid Burhan Khalid
#On StackOverflow.

Popularity 10/10 Helpfulness 3/10 Language python

Source: Grepper

Tags: csv

Link to this answer
Share Copy Link

Contributed on Jun 22 2020

ayaan

0 Answers Avg Quality 2/10

Read .csv file and write in a table

Contents

More Related Answers

Read .csv file and write in a table

Closely Related Answers

Write a table to CSV file python

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.