How to use CSV data in an SQL query

Question

I have a some data in an excel sheet in the form of a table. I want to run an sql query on that data. I am okay to use the data raw from the csv.

Is it possible to create a temporary view or table using that data within the query itself. I don't want to create a separate table for this excel data.

I assumed you are using SQL Server, however please provide which RDBMS you are using — user170442
– user170442, Commented Feb 21, 2017 at 11:30

score 3 · Accepted Answer · 2017-02-21 13:20:40Z

3

For SQL Server 2008 and above you can use OPENROWSET

In simplest form it will look like this:

SELECT * FROM OPENROWSET(BULK 'data.csv', SINGLE_CLOB) AS DATA;

Just remember to specify full file path.

edited Feb 21, 2017 at 13:20

answered Feb 21, 2017 at 11:29

user170442

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:00:17Z

2

There are a bunch of answers for this already... Have you searched?

You want to do something like this;

Select * 
into [temp_table$]
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\spreadsheet.xls;HDR=YES;IMEX=1',
'SELECT * FROM [SHEET1$]')

Like in this question: Get Excel sheet into temp table using a script

edited May 23, 2017 at 12:00

CommunityBot

11 silver badge

answered Feb 21, 2017 at 11:30

Milney

6,4472 gold badges21 silver badges34 bronze badges

Collectives™ on Stack Overflow

How to use CSV data in an SQL query

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related