I want to bring in CSV files from a directory on the same machine as my SQL Server. I am using BCP but keep getting and unexpected EOF error.

The table I am trying to import the CSV`s to has two columns. One is set up as text to hold the CSV file and the other is an timestamp.

Is it possible to pull the entire CSV into the one field and keep its form as a CSV? If so, what would my format file look like? I want to store these CSVs in the database and let users hit them with ASPs to get archived versions of the same reports.

Any help would be greatly appreciated...I don`t have much hair left.

Thanks-

If replying by email, just yank the "nospam" out.