Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dnf999
Constraint Violating Yak Guru
253 Posts |
 Posted - 2007-10-17 : 07:35:47
|
| Hi I am currently trying import a Concordance database .txt file into SQL server 2005 through the import wizard and get the following error:The preview sample contains embedded text qualifiers (þ). The flat file parser does not support embedding (delimiter - chr(20) text qualifier - chr(254) þ)Do you know if SQL has fix to allow embedded text qualifiers now??Many thanks! |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-17 : 07:59:52
|
| Doesn't it work if you put SPACE in the "Column delimiter" and Alt-0254 in the Text Qualifier?Or is that what you tried?Kristen |
 |
|
|
dnf999
Constraint Violating Yak Guru
253 Posts |
Posted - 2007-10-17 : 12:41:54
|
| Hi KirstenI have not tried that.My option for the column delimiter is greyed out and I cannot enter anything in there. Also, when you say enter Alt-0254 do you mean type that in there?A small sample of the data looks like this:þBATESBEGþþBATESENDþþMULTI_DOCþMUN00010037þþMUN00010044þþNoMany thanks!!! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-17 : 13:02:46
|
| "My option for the column delimiter is greyed out and I cannot enter anything in there"It shouldn't be like that, so something else must be disabling that. For example setting "Fixed length" instead of "Delimited" record type. Worth fiddling with the other settings to see if you can Enable the Column Delimiter. Then just type a SPACE in there (if its not one of the provided choices)"Also, when you say enter Alt-0254 do you mean type that in there?"Yup. Hold down the ALT keyType 0 2 5 4 (on the numeric pad, not along the top of the QWERTY bit)Release the ALT keyYou'll get the þ symbol - or you can cut&paste it in from somewhere - like this page!!Kristen |
|
|
|
Scirocco
Starting Member
1 Post |
Posted - 2007-10-19 : 14:50:49
|
| I am trying to do the exact same thing, and getting the exact same error. Space is decimal 32, Hex 20 but the column delimeter in concordance files is decimal 20, Hex 14. Using a space for the column delimiter will not work. If I fnd a solution to this today I will post it here. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-20 : 02:51:14
|
| I can't think of a way that you can enter any delimiter with a value less then decimal-32 / hex-0x20 |
|
|
|
dnf999
Constraint Violating Yak Guru
253 Posts |
Posted - 2007-10-27 : 09:44:20
|
| The only way I have got this concordance data into my SQL database is by importing the data into Acccess (set database template) and then importing into SQL.It works, but seems a bit long winded, and due to size restrictions of Access, you will run into troubles when trying to import large (over 2gb) tables into Access. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-27 : 10:19:31
|
| How do you get the data into Access with a delimiter < [less than] ASCII-32 ? |
|
|
|
dnf999
Constraint Violating Yak Guru
253 Posts |
Posted - 2007-10-30 : 07:48:09
|
| I used the delimiters:(delimiter - chr(20) text qualifier - chr(254) þ) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-30 : 07:58:25
|
| Sorry, I was meaning:Is there some import utility in Access that allows you to specify the delimiter in BINARY rather than as a specific CHARACTER? (or did you import the database using a program that you wrote?)Kristen |
|
|
|
|
|
|
|
|
Error importing