troubleshooting Question

OPENROWSET CSV NO header

Avatar of Dave Roger
Dave RogerFlag for United States of America asked on
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008
8 Comments1 Solution4902 ViewsLast Modified:
I have sample csv file with no header.
I would like to read it into MSSQL.
I am getting error;
"Msg 492, Level 16, State 1, Line 5
Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name "$10#00" is a duplicate."


SELECT *
FROM   OPENROWSET('MSDASQL',  
   'Driver={Microsoft Text Driver (*.txt; *.csv)};DefaultDir=C:\work\;HEADER=NO;',
   'SELECT * FROM [test1.csv];'
)   test1.csv

I can use OPENDATASOURCE, but I have a lot of files and it takes much longer.
ASKER CERTIFIED SOLUTION
Mark Wills
Topic Advisor
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros