473,396 Members | 2,039 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

read data from excel file (urgent)

Hi......all....
can any body tell me how can we upload excel file & send the excel
file data in database.
I;m not able to do........please help me......
thanks in advance
Jan 16 '08 #1
5 7276
<vi*******@gmail.comwrote in message
news:46**********************************@l32g2000 hse.googlegroups.com...
Hi......all....
can any body tell me how can we upload excel file & send the excel
file data in database.
I;m not able to do........please help me......
thanks in advance

Export from Excel to a CSV file then check out http://www.filehelpers.com/ .

Jan 16 '08 #2
"Todd Carnes" <to********@gmail.comwrote in message
news:eX**************@TK2MSFTNGP02.phx.gbl...
<vi*******@gmail.comwrote in message
news:46**********************************@l32g2000 hse.googlegroups.com...
>Hi......all....
can any body tell me how can we upload excel file & send the excel
file data in database.
I;m not able to do........please help me......
thanks in advance


Export from Excel to a CSV file then check out http://www.filehelpers.com/
.

Actually, you don't even need to do the export. Just use
http://www.filehelpers.com/ . It can handle Excel files.

Todd

Jan 16 '08 #3
thanks 4 given reply but my problem is that i want only the excel file
as in browser & after that validate that data & save into uor
database.........
tell me 4 this problem
thanks
On Jan 16, 10:39*am, "Todd Carnes" <toddcar...@gmail.comwrote:
"Todd Carnes" <toddcar...@gmail.comwrote in message

news:eX**************@TK2MSFTNGP02.phx.gbl...
<vimal....@gmail.comwrote in message
news:46**********************************@l32g2000 hse.googlegroups.com...
Hi......all....
can any body tell me how can we upload excel file & send the excel
file data in database.
I;m not able to do........please help me......
thanks in advance
Export from Excel to a CSV file then check outhttp://www.filehelpers.com/
.

Actually, you don't even need to do the export. Just usehttp://www.filehelpers.com/. It can handle Excel files.

Todd
Jan 16 '08 #4
i want only the excel file
as in browser & after that validate that data & save into uor
database.........
Could you repeat that in different words? I'm having difficulty
understanding exactly what you want... in a browser, you can use an
<input type="file" /(with the correct form-encoding for multipart-
mime) to allow the user to attach a file for upload. At the web-server
you can read this uploaded stream - for instance in ASP.NET it is
accessed by Request.Files (multiple files can be uploaded at once on
different inputs).

Now; most parsers will accept a stream as input; for instance, I do
something *very* similar using a CSV reader. I'm guessing that
filehelpers will do similar. And as a last resort you can save the
request stream to a temp area, and then point the parser at the temp
file [parsing direct of the request is cleaner IMO].

If you want the browser experience to *be* Excel, then you might want
to look at something like sharepoint, and customising the behavior
there.

Marc
Jan 16 '08 #5
Hi,
You need to have the excel runtime installed in the server. Can you upload a
CSV file instead?

--
Ignacio Machin
http://www.laceupsolutions.com
Mobile & warehouse Solutions.
<vi*******@gmail.comwrote in message
news:57**********************************@d21g2000 prf.googlegroups.com...
thanks 4 given reply but my problem is that i want only the excel file
as in browser & after that validate that data & save into uor
database.........
tell me 4 this problem
thanks
On Jan 16, 10:39 am, "Todd Carnes" <toddcar...@gmail.comwrote:
"Todd Carnes" <toddcar...@gmail.comwrote in message

news:eX**************@TK2MSFTNGP02.phx.gbl...
<vimal....@gmail.comwrote in message
news:46**********************************@l32g2000 hse.googlegroups.com...
Hi......all....
can any body tell me how can we upload excel file & send the excel
file data in database.
I;m not able to do........please help me......
thanks in advance
Export from Excel to a CSV file then check
outhttp://www.filehelpers.com/
.

Actually, you don't even need to do the export. Just
usehttp://www.filehelpers.com/. It can handle Excel files.

Todd

Jan 16 '08 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: cv | last post by:
Hi all, I have to copy two set of data from 2 files(notepad/excel) say, products and their corresponding prices to list/textarea/table. I should be able to retrieve the product and corresponding...
3
by: sridevi | last post by:
Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works...
0
by: Peter | last post by:
I am having a problem reading an Excel file that is XML based. The directory I am reading contains Excel files that can be of two types. Either generic Microsoft based or XML based. I am reading...
7
by: vbnetdev | last post by:
My boss wants this done in a day. I would be happy with a week! Anyway, I have a dataset filled with data and need to populate an MS word chart with it when writing a report. Any tutorials or...
0
by: napstar | last post by:
I have an excel file with data.I want to pull data from the excel file into a table in access.The data in excel has products and customers who buy these products and sometimes 1 customer can buy many...
0
by: priyanka1915 | last post by:
hello i want to read the data from url of excel suppose excel file is situated in this link "http://localhost/books.csv" how should i retrieve the data ?? please help me its urgent
3
by: sejal17 | last post by:
hello Can any one tell me how to read multiple worksheets from a single excel file.I have stored that excel in xml file.so i want to read that xml that has multiple worksheet.And i want to store...
3
by: sejal17 | last post by:
hello Can any one tell me how to read multiple worksheets from a single excel file.I have stored that excel in xml file.so i want to read that xml that has multiple worksheet.And i want to store...
13
by: Peter | last post by:
VS2008 ans ASP.NET 3.5, Office 2003 What is the best way to run Excel Template from ASP.NET web page were the Excel is only installed on the client without any ActiveX? If so can someone point...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
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,...
0
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...
0
tracyyun
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...
0
agi2029
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,...
0
isladogs
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.