Very Computer

Help please!!!!

I've got a CSV file of Spanish text that I need to import using
Microsoft SQL Server 7.   When I use the import wizard I end up with
non standard characters not being correctly converted i.e. becomes
.  I've tried playing around with OEM rather ANSI File Types on the
Import but whereas the preview using OEM looks correct I'm unable to
specify a column delimiter.

I've spent most of the day either trying different methods or looking
on the web but no joy.   I've found plenty of other people with the
same question but noone who has been able to answer it.

Any help would be gratefully received & if you're anywhere near Henley
in the UK I'd gladly buy you a drink :-).

Can you please also post any replies here.

Thanks in advance,

Andee

------
Dwayne Lanclos
Microsoft SQL Server Support

Please reply only to the newsgroup so that others can benefit.
When posting, please state the version of SQL Server being used and the
error number/exact error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Quote:> What is the code page of your SQL Server 7.0?  (run sp_helpsort)  If I had
> an example of your data and the table you are trying to load, I might be
> able to help you.  Have you tried BCP?

> ------
> Dwayne Lanclos
> Microsoft SQL Server Support

Thanks for your post.   sp_helpsort provides the following:-

Unicode data sorting  
----------------------
Locale ID = 1033      

 case insensitive, kana type insensitive, width insensitive

Sort Order Description
------------------------------------------------------------------------------------------------------------------------------------
Character Set = 1, iso_1
    ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 52, nocase_iso
    Case-insensitive dictionary sort order for use with several We
    stern-European languages including English, French, and German
    .  Uses the ISO 8859-1 character set.

Characters, in Order                                                  

------------------------------------------------------------------------------------------------------------------------------------

  ~   ? | ? a ? ? - ? 2 3 ? ? 1 o ? ? ? ?
  ? 0 1 2 3 4 5 6 7 8 9 A=a = = ?=a ?=? ?=? ?=? ?=? B=b C
 =c ?=? D=d E=e = = = ?=? F=f G=g H=h I=i = = ?=? ?=? J
 =j K=k L=l M=m N=n ?=? O=o = = ?=? ?=? ?=? ?=? P=p Q=q R=r S
 =s ? T=t U=u = = ?=? = V=v W=w X=x Y=y Y=y ? Z=z D=e T=t

All I'm trying to do is load up a spreadsheet that contains data
similar to the following:-

NodeId  Seq     Language        Value
0       4       SP              Fecha memorable (dd/mm/aaaa)
200     8       SP              Valoracin en

One of the things that is making it slightly more complicated is the
contents of the 'value' column.   Some of these cells contain CR/LF
within the data & also , " & '.   I've tried saving the spreadsheet as
Unicode .txt, ms-dos .csv & a multitude of other ways but always run
into either it not translating the Spanish characters correctly when
using the SQL server import wizard or it not correctly handling the
CR/LFs.

I don't know what you mean by BCP - I'm a very novice SQL Server user!

Thanks again,

Andee

create table andee (nodeid integer, seq integer, language varchar(10),
value varchar(40))

I then copied the sample data you provided to Notepad and saved as an ascii
file.  I was then able to import the data into the table and the accented
"o" appears just as it was in your newsgroup posting.  I would probably
need your original .csv file to try to reproduce your problem.

Have you tried doing a copy and paste from your original .csv file to
Notepad and then saving and loading from that?

------
Dwayne Lanclos
Microsoft SQL Server Support

Please reply only to the newsgroup so that others can benefit.
When posting, please state the version of SQL Server being used and the
error number/exact error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Quote:> > What is the code page of your SQL Server 7.0?  (run sp_helpsort)  If I
had
> > an example of your data and the table you are trying to load, I might
be
> > able to help you.  Have you tried BCP?

> > ------
> > Dwayne Lanclos
> > Microsoft SQL Server Support

> Hi Dwayne,

> All I'm trying to do is load up a spreadsheet that contains data
> similar to the following:-

> NodeId     Seq     Language        Value
> 0  4       SP              Fecha memorable (dd/mm/aaaa)
> 200        8       SP              Valoracin en

> One of the things that is making it slightly more complicated is the
> contents of the 'value' column.   Some of these cells contain CR/LF
> within the data & also , " & '.   I've tried saving the spreadsheet as
> Unicode .txt, ms-dos .csv & a multitude of other ways but always run
> into either it not translating the Spanish characters correctly when
> using the SQL server import wizard or it not correctly handling the
> CR/LFs.

> I don't know what you mean by BCP - I'm a very novice SQL Server user!

> Thanks again,

> Andee