Hello~ ^^
I have a question about getting excel data with oledbconnection .
I entered '23190000' to Excel Cell and changed Column width to small, then
the value chaged to 2E+07 or ####.
And I saved this file...(maybe both data saved..viewed data and original data)
when openning this file with oledbconnection , I got '2E+07' without original
data '23190000'.
I'd want to get original data '23190000' instead of viewed data like
'2E+07', '#####', '23,190,000'.
I used connection string like this..
OleDbConnection db = new OleDbConnection
("Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=" + m_sarFileName[iIndex]
+";Extended Properties=Exce l 8.0;" );
Thank you... 1 1721
Try looking into the NumberFormat property of the Cells.
"Antonio. kim" wrote: Hello~ ^^ I have a question about getting excel data with oledbconnection .
I entered '23190000' to Excel Cell and changed Column width to small, then the value chaged to 2E+07 or ####. And I saved this file...(maybe both data saved..viewed data and original data) when openning this file with oledbconnection , I got '2E+07' without original data '23190000'. I'd want to get original data '23190000' instead of viewed data like '2E+07', '#####', '23,190,000'.
I used connection string like this.. OleDbConnection db = new OleDbConnection ("Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=" + m_sarFileName[iIndex] +";Extended Properties=Exce l 8.0;" );
Thank you... This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Ksenia Marasanova |
last post by:
Hi,
I have a little problem with encoding. Was hoping maybe anyone can
help me to solve it.
There is some amount of data in a database (PG) that must be inserted
into Excel sheet and emailed. Nothing special, everything works.
Except that non-ascii characters are not displayed properly.
The data is stored as XML into a text field. When I use pgsql it's
displayed good in the terminal. Now I run my script and print data
|
by: DAVID SCHULMAN |
last post by:
I've been trying to perform a calculation that has been running into
an underflow (insufficient precision) problem in Microsoft Excel, which
calculates using at most 15 significant digits. For this purpose, that
isn't enough.
I was reading a book about some of the financial scandals of the
1990s called "Inventing Money: The Story of Long-Term Capital Management
and the Legends Behind it" by Nicholas Dunbar. On page 95, he mentions
that...
|
by: Michael Sanford |
last post by:
I'm getting a Sysmte.IO.FileNotFoundException when executing the code
below.
It is straight from the example. This works on one machine, but not
the other. Other benign calls invoke the same misbehavior which as
ActiveWorkbook or Active Worksheet.
Please help!
peace,
- mike
|
by: |
last post by:
I wrote a class in VB.NET to export the contents of a datagrid to Excel. It
works perfectly on my machine, but it fails on my customers' PCs that have
identical versions of Win XP (SP1) and Excel (SP1) installed.
The error is:
System.Runtime.InteropServices.COMException(0x800A03EC): Exception from
HRESULT: 0x800A03EC.
at Microsoft.Office.Interop.Excel._Worksheet.Paste(Object Destination,
Object Link)
at...
|
by: syvman |
last post by:
Hi everyone... I am pulling my hair out trying to do this, and was
wondering if someone could give me some assistance...
I have an Excel spreadsheet containing several worksheets. I'd like to
be able to take all of the data from the second column (B) of each
worksheet and append that raw data to an access table. The columns in
the spreadsheet do not have headers for use as field names (it's my
assumption that my table should have a...
| |
by: Judy |
last post by:
I'm searching for some data. After getting the data from sql, i'm using
stringbuilder and then i'm passing this as a binary stream. I am trying
to display an Excel file of this data in a browser, but I am being
prompted to open/save the file instead. I don't want the user to be
prompted; I just want the Excel to be displayed. Here is the code:
Dim binaryData() As Byte
binarydata = GetDataHere()
Response.ContentType =...
|
by: radink |
last post by:
I have an established secured access database. I would like to read
fields in the Access DB while im in excel via the external database
query tools. However im getting an error about not having permission
to the db. I enter my crudentials and I still get the error. Any ideas
on how to go about this?
|
by: chike_oji |
last post by:
Please can someone help me. I am writing a web application,
that allows for the upload of an excel sheet into the database.
I have an upload button and a save button.
The upload button allows for the retrieval of the excel data into
a DataTable, which is bound to a GridView for previewing before
saving to the Database.
But, whenever I click on the save button, I lose the DataTable's data,
so I lose the data I want to save to the...
|
by: ammoos |
last post by:
Hi Friends
I am getting the following error when I am trying to read data from an excel sheet using sql script
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not give any information about the error.
OLE DB error trace .
If I save the excel file in the database server machine, then it will work fine.. I am getting this error message when I save the excel file in any other machine in the network and trying...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |