Importing from a csv file

[cricketer1]

How can I import data from a csv file using DTS?

 

[tlbroadbent]

Yes! Just start the DTS Import Wizard, select text as the source, point to the file, and select delimited on the next screen. Terry

http://members.home.net/tlbroadbent/index.htm

 

[cricketer1]

Still doesn't work...this is a:
Microsoft Excel Comma Separated Values File

It's not the regular csv text format. any suggestions?

 

[tlbroadbent]

What happens? Do you get an error? Does your system hang? Does it import incorrectly?

I'm not familiar with Microsoft Excel Comma Separated Values Files. What type file is it? Can you open it in a text editor like Notepad? Terry

http://members.home.net/tlbroadbent/index.htm

 

[cricketer1]

Basically, it doesn't accept any row delimiter that I give it, giving an error "Row Delimiter Not Found". But I can open it in Notepad.

I have imported regular csv files into SQL server before this, but this one is strange. By default it opens in excel and not Notepad. If I save it as a comma delimited csv file within excel then SQL Server accepts it. But I can't do that manual, I want it to be automated DTS import.

 

[tlbroadbent]

Have you tried selecting different row delimiters in the DTS Import Wizard? The default is {CR}{LF}. I would try {CR}. That is very commonly used as a row delimiter. Terry

http://members.home.net/tlbroadbent/index.htm

 

[cricketer1]

I have tried all the row delimiters without any luck. The only thing I can think of now is to write a program to read this file and save it as a plain text file and then import this to SQL Server.

Thanks for your time and help. And if you come across a similar file and find a solution please post it here.

 

[foxdev]

I import CSV files saved from Excel (as CSV) every day. There must be something else to this puzzle. If the data is not sensitive, could you post a couple of lines of it? Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com