data import using wizard

Hello,
I'm having problem importing a simple comma delimited text file into a
simple 3 fields table. I used the DTS wizards, I got to pick my source text
file, but on the following step, it gave me the following error message.
"Invalid delimited data text qualifier, must be followed by a column
delimiter",
I don't understanding what it means, my text file looks fine, is a simple 3
columns text file. Please help this dumb beginner.
Any good beginner book on SQL 2000 I should read'
Thanks in advance for any helpFor sql server - SQL SERVER IN 21 DAYS (BASICS)
FOR dts basics - step by step by Microsoft
Regards
R.D
"SQLbeginner" wrote:

> Hello,
> I'm having problem importing a simple comma delimited text file into a
> simple 3 fields table. I used the DTS wizards, I got to pick my source te
xt
> file, but on the following step, it gave me the following error message.
> "Invalid delimited data text qualifier, must be followed by a column
> delimiter",
> I don't understanding what it means, my text file looks fine, is a simple
3
> columns text file. Please help this dumb beginner.
> Any good beginner book on SQL 2000 I should read'
> Thanks in advance for any help|||I mean SQL SERVER DTS - STEP BY STEP( see if possible, google it for free
soft copy)
Regards
R.D
"SQLbeginner" wrote:

> Hello,
> I'm having problem importing a simple comma delimited text file into a
> simple 3 fields table. I used the DTS wizards, I got to pick my source te
xt
> file, but on the following step, it gave me the following error message.
> "Invalid delimited data text qualifier, must be followed by a column
> delimiter",
> I don't understanding what it means, my text file looks fine, is a simple
3
> columns text file. Please help this dumb beginner.
> Any good beginner book on SQL 2000 I should read'
> Thanks in advance for any help|||>> I don't understanding what it means, my text file looks fine, is a simple
Perhaps you might want to verify the input data, since the error message
points to a badly formatted source file. If the file size is smaller,
consider loading into a spreadsheet and see if it looks OK.
For beginners, SQL Server Books Online trumps anything out there.
Anith|||Thanks guys!
I finally figured out something though. Following is a small sample of my
text file that created from Excel using the (csv comma delimited) option:
"12345","Smith","Jones"
"45678","Lewis", "Shank"
On the DTS 'Select File Format' page, it has the following:
File type: ANSI
Row Delimiter: {CR} {LF}
Text Qualifer: Double Quote {"}
But it does not recognize the double quote as the Text Qualifer, if worked
beautifully when I stripped out the double quote. Is there a way to get
around that because 90% of the files I receive have the double quote'
Thanks!!
"Anith Sen" wrote:

> Perhaps you might want to verify the input data, since the error message
> points to a badly formatted source file. If the file size is smaller,
> consider loading into a spreadsheet and see if it looks OK.
>
> For beginners, SQL Server Books Online trumps anything out there.
> --
> Anith
>
>|||You could write a simple asp page where you can browse to the text file
(using file system object) you receive. Then write a loop that reads each
line and loads it into a temp variable and uses the replace function to
replace all quotes with empty space ("").
Or you can get the people who send you the text file to get their shit
straight and stop inserting double quotes. But the business usually doesn't
work with the techies, they usually want you to work around their horse shit
.
Anyways, the code for that should be simple. If you need help, look up code
on the File system object, opening/reading a text file line by line, and the
replace function.
RG
SQLbeginner wrote:
>Thanks guys!
>I finally figured out something though. Following is a small sample of my
>text file that created from Excel using the (csv comma delimited) option:
>"12345","Smith","Jones"
>"45678","Lewis", "Shank"
>On the DTS 'Select File Format' page, it has the following:
>File type: ANSI
>Row Delimiter: {CR} {LF}
>Text Qualifer: Double Quote {"}
>But it does not recognize the double quote as the Text Qualifer, if worked
>beautifully when I stripped out the double quote. Is there a way to get
>around that because 90% of the files I receive have the double quote'
>Thanks!!
>
>
>[quoted text clipped - 6 lines]
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200509/1|||There's a space after the comma after Lewis.
Bruce Dunwiddie
http://www.csvreader.com|||That was my typo, there should not be a space anywhere.
"shriop" wrote:

> There's a space after the comma after Lewis.
> Bruce Dunwiddie
> http://www.csvreader.com
>