Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Is it a bug of SQLXL? (Read 2516 times)
cc
YaBB Newbies
*


I Love SQL*XL

Posts: 1
Is it a bug of SQLXL?
23.09.08 at 14:57:16
 
Help! I used SQLXL InsertMultipleRows and tried to export my excel data into oracle. All data were successful except one that was changed the value.
the original data value(in excel sheet) is 0.0762195121951219  but in Oracle was become 0.076219512195122.
 
the table field descript is NUMBER(31,26).
 
I also used the VBA like below:
 undecided undecided
Sub InsertMultipleRows()
  SQLXL.InsertRecordset Table:="Authors", Columns:="Au_ID,Author,[Year Born]", DataRange:=Range("$A$6:$C$11"), PromptOnError:=False, SortToStatus:=True, CommitFrequency:=50, Orientation:=1, Silent:=True, Feedback:=True
End Sub
 
but it got same wrong. Who can tell me how to solve the problem? Is it a bug of SQLXL?
Back to top
 
 
Email   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Is it a bug of SQLXL?
Reply #1 - 28.09.08 at 21:36:40
 
I cannot reproduce the problem. I have tested this with Oracle 8.1.7. I connected with MSDAORA and performed the following test:
 
create table test (a  number)
 
Used multiple rows insert to insert the value of 0.0762195121951219
 
Then I ran the query: select * from test
 
It returned the value 0.0762195121951219 just fine.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1