Help in Visual Basic.

Question

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

pratap reddy · Answer

1:Allows an Internal or External user (with respect to the Organization where deployed) to Query and Analyze the XML data that are stored on the server. Nested Queries can be performed on the search results of the previous query. Both Graphical (Pie Bar and Line - 3D Type) as well as Tabular listing of the results are displayed dynamically. The above displays can be printed from within the view. Any Admin level user for each type of XML data file can set the specific columns in the Tabular data 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. 3: Online Classifieds is an B to B application where the basic functionality of the project is a .NET portal where the user can advertise the Business Requirements in Internet any type of classifieds they can advertise through this portal. Online Classifieds is a basic yet fully functional online classifieds system that you may use as a framework to create an expanded system or use ‘as is’. The main aim of the project specified at customer’s point of view is to advertise the details of their products or company’s details through banners or advertisements. First the customers as to get registered on the site or portal avail before he needs to make a classifieds. The project is broken down into several steps that will allow to complete is rapidly and give an opportunity to expand on the design once it is completed. Classifieds are Mainly 4 Modules: - Post an add Latest ads my classifieds Search 4: This project will fulfill the needs of Hospitals Polyclinics and Pharmacies developed for Bakthi Vedanta Hospital . This project involved deployment of the product with some customization as per the client’s requirements. The customization involved addition of new modules (complaint management Equipment maintenance and blood bank) designing of some new screens in the existing modules. Also provided interface for Data porting from their existing system to the current system and automating their backup and recovery process. This system can streamline the collection organization and generation of summary data and it can provide new strategic tools for decision support financial planning physician nurse recruitment and marketing

jc mandapat · Answer

I suggest you put first the contents of the excel file into a dataset then you can transfer it to the database

Desmond · Answer

Sorry. I cant find it. Care to help out ? Sorry

Mahesh Chand · Answer

See Office Interoperability section of www.vbdotnetheaven.com for sample applications.