SQL 7.0 DTS Import of CSV files 
Author Message
 SQL 7.0 DTS Import of CSV files

I have been experiencing some problems importing CSV files using DTS.  It
does not always recognise the " characters around items of text the CSV
file.  Some columns get read including the quotes and others without.

Has anyone else experienced this problem and if so - has anyone found a
solution - or dare I even suggest it......but am I doing something silly??

Paul Humphris



Sat, 22 Sep 2001 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. SQL 7.0 DTS Import of CSV Files

2. SQL 7.0 DTS Import of CSV files

3. SQL 7.0 DTS Import of CSV files

4. Dts Import Question:Importing Csv file in an existing SQL2000 table with row-level conditions

5. Importing unicode CSV file via DTS

6. DTS import csv - dynamic file name

7. Importing unicode CSV file via DTS

8. DTS-CSV import file has dangling comma at the end of the record

9. DTS import error from CSV file - cannot insert value NULL

10. Importing a 66 gigabyte csv file into SQL2000 using DTS

11. DTS - importing CSV file drops last record

12. DTS and importing CSV/ascii files?


 
Powered by phpBB® Forum Software