tags:

views:

16

answers:

1
+1  Q: 

SQL Server BCP only one row inserted?

I'm using an FMT file to BCP a csv file into a an SQL Server Box - everything is fine, but only the first row of the 5 line file is getting inserted.

I think it is the line feed settings for the terminator of the final column - but how do I view and edit the line feeds in the csv file?

A: 

Notepad++ is a free editor which you can use to view (View / Show Symbol / Show End of Line) and edit (Edit / EOL Conversion / Windows Format) the end of lines.

Bill  2010-08-25 04:56:37

related questions

C# Exception Handling continue on error
Exporting tab-delimited files in SSRS 2005
How can I join a list into a string (caveat)?
When reading a CSV file using a DataReader and the OLEDB Jet data provider, how can I control column data types?
Looking for tool to generate random CSV data
csv api for java
in rails, how to return records as a csv file
Import *variable record length* CSV file using SSIS
asp.net Convert CSV string to string[]
What's the best way to extract table content from a group of HTML files?
How do I save each sheet in an Excel workbook to separate CSV files with a macro?
Program for working with large CSV Files
How do I best generate a CSV (comma-delimited text file) for download with ASP.NET?
SSIS: Adding a constant column value when doing a CSV to SQL conversion
Java code to import CSV into Access
Parsing XML using unix terminal
CSV (or sheet in XLS) to SQL create (and insert) statements with .Net?
Generate Insert SQL statements from a csv file
Split a string ignoring quoted sections
FileHelpers performance
CSV string handling
What is a good web-based Grid that accepts Excel clipboard data?
CSV File Imports in .Net
How to export data from SQL Server 2005 to MySQL
Converting CSV File to XML in Java