How do i load datas from Excel spreadsheet into the database.
Lets say i have a web application that allows me to browse my directory for the .xls file.
After locating the file, all i need to do is to enter "OK" and the datas from the Excel spreadsheet will be automatically recorded into the database.
Anyone know of any examples or source codes where i can take as references?
Your help is appreciated. Thanks for your time and sorry for the trouble.
-Desmond
Loading
pratap reddyPosted Oct 30, 2006, 5:33 AM
2:SQL Tool provides quick and easy database development and administration. It is a powerful, low-overhead tool that makes database and application development faster and easier and simplifies day-to-day administration tasks. Whether you are application developer, DBA. Tool offers specific features to make you more productive than ever before.This project contains the 3 modules and they are.Create: which provides the user to create the database objects like tables, views, synonyms, sequences, snapshots, indexes, etc.Alter: which provides the user to alter the database objects like tables, views, synonyms, sequences, snapshots, indexes, etc.View: This provides the user to view the data stored in the various database objects like tables, views, synonyms, sequences, snapshots, indexes, etc.
jc mandapatPosted Oct 30, 2006, 2:20 AM
DesmondPosted Oct 26, 2006, 11:22 AM
Mahesh ChandPosted Oct 24, 2006, 11:37 AM