load data from .csv file using OpenRowset

Question

Viewing 6 posts - 1 through 5 (of 5 total)

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

thasteve SSCrazy Points: 2707 More actions · Answer 1

this should work work

INSERT INTO ...

SELECT ...

FROM OPENROWSET ( ....

sharma-691993 SSCrazy Points: 2194 More actions · Answer 2

Thanks... Can you give me the provider name..

with complete script

sharma-691993 SSCrazy Points: 2194 More actions · Answer 3

Thanks... Can you give me the provider name..

with complete script

thasteve SSCrazy Points: 2707 More actions · Answer 4

INSERT INTO tablename

SELECT *

FROM

OPENROWSET ('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=C:\testfolder;', 'SELECT * from test.csv');

sharma-691993 SSCrazy Points: 2194 More actions · Answer 5

Hi..

How to do SELECT * INTO..

Because i don't want to create the table..

I tried in below way

SELECT * INTO XLImport55 FROM OPENROWSET ('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=D:\Test\;', 'SELECT * from TEST.csv');

It works as everything iserted in one column.

How to set delimiter ?