Updating unicode text in Oracle from Excel



  • 1. Better way to merge datasets
    I'm building a simple db archiving function. Basically, filtering records from a DS based on date and inserting them into an empty archiveDS. using a DataRow[] OldRecs = myDataSet.Tables["OriginalData"].Select("Date < 'somedate' )); work nicely and fast. However putting the records into the archive dataset is slow: ArchiveDataSet.Merge(OldRecs); ArchiveDataSet has the same schema as myDataSet and is empty prior to the merge. Is there a faster way to do this?
  • 2. DataSet Erroe
    Hi I have the bug with the Article ID Article ID : 815119 but the problem is that i have it at run time "sqlDataAdapter1.Fill(dadaSet11)" , while at design time i can fill the dataset from the dataadapter with no problem it gives me the error An unhandled exception of type 'System.ArgumentException' occurred in system.data.dll Additional information: Invalid element value workstation id=IBM;packet size=4096;user id=sa;data source="SVR1\SQLSVR1";persist security info=True;initial catalog=northwind;password="P@ssw0rd". -- Ammar S. Mitoori IT Head QIMCO Co. Tel : +9744831199 Mobile : +9745378400 Fax : +9744831643
  • 3. ADO.NET why use multiple tables in a dataset
    I'm having a hard time understanding why you would work with more than one table in a dataset. There is a common example where you add the northwind Customers and Orders tables into one dataset and then work with the data with a DataRelation object. Why would you do this when you could just create a stored procedure that joins the 2 tables together and just have 1 table in your dataset?
  • 4. ADO Query Error 'Path not found'
    Newbie to this group, but been doing VB for a long time and ADO in the past 2-3 years off and on. I have a OLE connection that I set up in a UDL file which is on a network share and to which I refer with a UNC Path name, but which connects fine. When I try to Execute a query, however, I get Error 76 'Path not found.' I don't know that I've seen that one before. It's strange, 'cause it doesn't quite make sense to me--what 'path'?? TIA!
  • 5. Dataform wizard
    Hi, I created a new dataform by using the dataform wizard (VB.NET). I delete one or more records and then I close the form and open it again. I add one record but i when i do so I always get a double record. Tx

Re: Updating unicode text in Oracle from Excel

Postby Val Mazur » Sat, 21 Aug 2004 07:20:25 GMT

Hi Magnus,

Try to use parameter for you INSERT statement and declare it as adVarWChar, 
which is a Unicode string

Dim loParameter as ADODB.Parameter
Dim locommand as ADODB.Command



Set loCommand = New ADODB.Command
Set loCommand.ActiveConnection = conn
loCommand.CommandText = sSQLStr

Set loParameter = loCommand.CreateParameter("Param1", adVarWChar, 
adParamInput, 10)
loParameter.Value = sData
loCommand.Parameters.Append loParameter
Val Mazur
Microsoft MVP

"Magnus Olofsson" <Magnus  XXXX@XXXXX.COM > wrote in 

Similar Threads:

1.Excel - Paste Special text or Unicode Text

i have two excel files, one that has formulas and one that uses raw values.  
I need to copy the values from the first sheet to the second one and use 
Paste Special and Values.  However, sometimes the normal Paste Special box 
does not appear, but another box that says Paste/Paste link with the options 
of "text" or "Unicode text" appears.

Does anyone know what that happens???

2.How to put traditional Chinese text into Unicode Oracle 9i database via Internet Explorer

Hello wisers,

We are testing a system which is developed on top of Oracle 9iAS. The
client PCs are using Internet Explorer to access the system. We are
sure that the Oracle 9i database server is set to use Unicode. The
Oracle 9i database server and Oracle 9iAS server are now running on
English Windows 2000 server. With client PCs running on traditional
Chinese Windows 2000 or traditional Chinese Windows XP, via Internet
Explorer we put traditional Chinese text into the system then query the
data again, it displays in inverted question marks.

1. How to resolve the problem?
2. Does the Internet Explorer View -> Code Unicode (UTF-8) setting
controls content display as well as keyin?
3. Or the system controls the code interpretation of keyin?


Return to ADO


Who is online

Users browsing this forum: No registered users and 10 guest