|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
data import using wizardHello,
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 help For sql server - SQL SERVER IN 21 DAYS (BASICS)
FOR dts basics - step by step by Microsoft Regards R.D Show quote "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 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 help I mean SQL SERVER DTS - STEP BY STEP( see if possible, google it for free
soft copy) Regards R.D Show quote "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 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 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 >> 3 columns text file. Please help this dumb beginner. points to a badly formatted source file. If the file size is smaller, consider loading into a spreadsheet and see if it looks OK. >> Any good beginner book on SQL 2000 I should read?? 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!! Show quote "Anith Sen" wrote: > >> I don't understanding what it means, my text file looks fine, is a simple > >> 3 columns text file. Please help this dumb beginner. > > 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. > > >> Any good beginner book on SQL 2000 I should read?? > > 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 sh*t 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 sh*t. 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: Show quote >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!! > > > >> >> I don't understanding what it means, my text file looks fine, is a simple >> >> 3 columns text file. Please help this dumb beginner. >[quoted text clipped - 6 lines] >> >> For beginners, SQL Server Books Online trumps anything out there. -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200509/1 That was my typo, there should not be a space anywhere.
Show quote "shriop" wrote: > There's a space after the comma after Lewis. > > Bruce Dunwiddie > http://www.csvreader.com > >  |
|||||||||||||||||||||||
Other interesting topics