Re: sql language problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Hi Ivan,

How did you do the import? You may have used bulk copy, but I'd recommend
you build your own routine, connecting to the table using the odbc driver
and then adding rows sequentially. It won't take long but you'll be able to
control things more precisely.

HTH,

Bernie Yaeger

"Ivan V via DotNetMonster.com" <forum@xxxxxxxxxxxxxxxxx> wrote in message
news:538CA48F663D6@xxxxxxxxxxxxxxxxxxxx
> Dear All:
>
> I am not sure this is the right place to ask this question, but I hope
> someone can help me out of that. I have a set of data which is in dbf
> format
> and need to import into my SQL2000 server. The langage in the dbf files is
> Protuguese, and after I finish my import into SQL server, the characters
> changed into some monster characters, but not the Portuguese. Anyonme
> knows
> what I need to do throughout the import process?? Thanks for all your
> attention!
>
> Best rgds,
> Ivan Vong
>
>
> --
> Message posted via http://www.dotnetmonster.com


.



Relevant Pages

  • Re: Dynamically Build Columns For Transfering Data
    ... we have bunch of .dbf files which we need to ... Is there any way in SSIS to drop and recreate SQL Server tables ... destination columns in a Transform Data Task. ... properties can I set dynamically for 1) The SQL statement used to ...
    (microsoft.public.sqlserver.dts)
  • sql language problem
    ... I have a set of data which is in dbf format ... Protuguese, and after I finish my import into SQL server, the characters ... changed into some monster characters, ... Ivan Vong ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Exception.txt.dest being overwritten on multiple calls to the same package
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. ... > for each iterated package. ... I suppose I can create a final task that combines the> similar files by name pattern, or better yet, loads them all into SQL> Exception tables for easier inspection. ... >>> I have a data migration package that pulls data from DBF files located> in ...
    (microsoft.public.sqlserver.dts)
  • Re: Database normalization
    ... You will have to recreate each of those dbf files as a table in order ... to import the data into SQL Server. ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: The Contrarians Development Language
    ... My personal preferences would probably be SQL Server, MySQL, and dbf ... The only one of those that's an odd choice is the dbf files, ...
    (borland.public.delphi.non-technical)