reading excel data through vb.net application

jinu

hello,

I need to run a vb.net application in different OSs like windows 2003,
windows 2000, windows 98 etc....
where only windows 2003 have built-in .net framework and to be installed in
others.
The problem is, client do not want to install excel in all the machines
where this application in intended to run BUT need to read an excel file for
data from all the machines.
I coded using OLEDB. but is it possible to read an excel file without excel
installed ?
i mean using VB.NET.
Please tell me how to do it.
Also please tell everything which is to be done to satisfy this requirement.

Thanks in advance

Jul 21 '05 #1

Subscribe Reply

2765

Paul Clement

On Tue, 24 Aug 2004 02:59:02 -0700, "jinu" <ji**@discussio ns.microsoft.co m> wrote:

¤ hello,
¤
¤ I need to run a vb.net application in different OSs like windows 2003,
¤ windows 2000, windows 98 etc....
¤ where only windows 2003 have built-in .net framework and to be installed in
¤ others.
¤ The problem is, client do not want to install excel in all the machines
¤ where this application in intended to run BUT need to read an excel file for
¤ data from all the machines.
¤ I coded using OLEDB. but is it possible to read an excel file without excel
¤ installed ?
¤ i mean using VB.NET.
¤ Please tell me how to do it.
¤ Also please tell everything which is to be done to satisfy this requirement.

Other than using ADO.NET and Jet OLEDB you would need to have Excel installed to access the Workbook
data.

The only other option would be to use the Office 2003 XML Reference Schemas:

http://www.microsoft.com/office/xml/default.mspx
Paul ~~~ pc******@amerit ech.net
Microsoft MVP (Visual Basic)

Jul 21 '05 #2

Similar topics

4672

reading from text file to excel file

by: mail2atulmehta | last post by:

Hi, I do not know if this is right place for this, but i need some help. I have a text file, whose values are seprated by a delimiter. I want to open this file in excel, ( not import it) . I have written the driver prg in c#. The code opens the file, but it is not writting the values from text file into excel file. I can not figure out the...

C / C++

5763

using EXCEL SHEET with ASP.NET

by: pmud | last post by:

Hi, I need to use an Excel Sheet in ASP.NET application so that the users can enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever the USER ENETRS needs to go to the SQL DATABASE, probably by the click of a button. Is this possible? & what is the BEST APPROACH for doing this? & also if any links are there do...

ASP.NET

8930

Problem reading text/numeric data from Excel

by: Scott M. Lyon | last post by:

I've just discovered a bug in some code I wrote a little while ago, and I need you guys' help to fix it. My program imports data from a standard Excel Spreadsheet (just with specific column headers). I used ODBC in my VB.NET program to read that spreadsheet into a dataset, to make it easy to manipulate. The code I use to read it is as the...

Visual Basic .NET

468

reading excel data through vb.net application

by: jinu | last post by:

.NET Framework

13214

reading data in to Access From Excel

by: nuti | last post by:

Hi all, I am fairly new to VB.I am trying to figure out as how to write a script so that i can read the data from an excel sheet to Access. can u guys please help me out? cheers, nuti

Microsoft Access / VBA

7024

Reading Excel in VB.NET

by: simchajoy2000 | last post by:

Hi, So I do actually know how to read excel into VB.NET using the following approach: With oConn2 .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & FilePath & ";Extended Properties=Excel 8.0;" .Open() End With

Visual Basic .NET

1602

Reading MS EXCEL data into SQL SERVER

by: Bharathi Kumar | last post by:

Hi, In my windows application, I have created excel.application object and read the excel data. I saved the data to sql server also. The problem Iam facing is when I create an instance of excel.application object, Microsoft excel process is being created and it stays though I terminate the application. I gave an input excel file, the...

.NET Framework

22484

Reading Excel sheet into DB Table

by: dba123 | last post by:

I need some help and direction on what classes and an example or two (article) on how to read an Excel Worksheet and insert one column into a database table column. I am using .NET 2.0 only. What namespaces and classes should I use and how? -- dba123

C# / C Sharp

10395

reading data from excel using OLEDB

by: =?Utf-8?B?U2hlZXMgQWJpZGk=?= | last post by:

I read an article on the link: http://support.microsoft.com/default.aspx?scid=kb;en-us;306572 related to reading data from Excel using OLEDB The topic's heading is: How to query and display excel data by using ASP.NET, ADO.NET, and Visual C# .NET I am trying with the same code in Visual Studio 2005 in ASP.NET application. The code i am using...

C# / C Sharp

7924

Problem With Comparison Operator <=> in G++

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. ...

C / C++

8122

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7673

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

5513

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

3653

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3640

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2113

transfer the data from one system to another through ip address

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

C# / C Sharp

1213

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

937

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General