473,396 Members | 1,846 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.

storing the excel information into database

Hi friends,
Here i want to store the excel file information into database........plzzzzz help me.......
Jun 4 '07 #1
9 2589
r035198x
13,262 8TB
Hi friends,
Here i want to store the excel file information into database........plzzzzz help me.......
Read sun's JDBC tutorial and try the program after that.
Jun 5 '07 #2
i had done a little bit of work on that......i will tell you wht i have done......
----first i have converted excel file into .txt file with tabseprator. And next i had writen a program to read that values. But if there is no value(in the cell) then it is showing some error of string tokenizer...... so plz help me...........
Jun 5 '07 #3
r035198x
13,262 8TB
i had done a little bit of work on that......i will tell you wht i have done......
----first i have converted excel file into .txt file with tabseprator. And next i had writen a program to read that values. But if there is no value(in the cell) then it is showing some error of string tokenizer...... so plz help me...........
You can start about telling the specific error you got and what you were trying to do when you got the error.
Jun 6 '07 #4
thanks for your help.........it's working fine...........finally i got it.
any way thanks for your help once again.............
Jun 6 '07 #5
thanks for your help.........it's working fine...........finally i got it.
any way thanks for your help once again.............
i have same problem that i want to store the excel file information into the database. but i am unable to get the whole information from the file.

please help me and give the source code to read from excel file and to store into the database table.

please help me...

advance thanks
Jun 21 '07 #6
r035198x
13,262 8TB
i have same problem that i want to store the excel file information into the database. but i am unable to get the whole information from the file.

please help me and give the source code to read from excel file and to store into the database table.

please help me...

advance thanks
No we don't give out source codes just like that. You have to put some of your own effort too if you want to get code. Read a tutorial about how to do it and try the code then come back if you get stuck with your code.

See the guidelines.
Jun 21 '07 #7
Hi,
I have writen a program which will store the excel file information into a oracle database.....You please provide the information clearly what u want.....
Jun 27 '07 #8
Hi,
I have writen a program which will store the excel file information into a oracle database.....You please provide the information clearly what u want.....
Hi,
I have written a program using odbc connection to read the values from excelsheet and insert into database.

but is there any other way to read the cells and insert into database without using configuring in odbc administrator console
Jul 5 '07 #9
Hi Bharat,
Will you be a bit more clear on what you have done...Iam not getting you clearly....................
Jul 6 '07 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: craig | last post by:
Some of the user interface components I am using (Infragistics) are capable of generating both XML and binary data that represents component configuration settings as defined by the user. I would...
2
by: Robert Hanson | last post by:
I am new to the asp.net application building and I have read the information regarding the storing of information using session vs cookies vs viewstate. I am asking for suggestions/guidance as to...
2
by: Brian Cryer | last post by:
I'm curious (as opposed to having a definite need), but given that I know how to serialize session information, does anyone know how in the .NET 1.1 framework I could write my own SessionProvider,...
0
by: tejas | last post by:
Hi everyone.i am working on VB6.0 i want to make a software using VB 6.0 as front end which retrives selected columns from as excel file and puts that in the database table. the excel file should...
2
by: MorrganMail | last post by:
Hi, I am writing an SQL query in which I need to compare two fields which are both storing time information. The datatype of the first field is Date/Time and the format is HH:MM. The second...
1
by: Beany | last post by:
Hi, Ok, im designing a new database, which is a product information database. Customers are given PC's, Mobiles and cameras, i want to use this database and keep track of these items..... I...
4
by: jack | last post by:
Hi. My project requires to upload the excel file and populate it into the database. By doing so it should also check whether the excel file selected is in the right format. for example if the...
1
by: Jeff | last post by:
Hey asp.net 2.0 at work we are about to start on a new project. Creating a website. My mananger has created the database. The database has a table holding user information (not that standard...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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
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...
0
jinu1996
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...
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,...

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.