Accessing Excel Database using ADO.NET

This simple program shows how access an access database using ADO.NET. It opens a database mcTest.mdb from your application directory.

Mahesh Chand

Jun 25, 2003 · Updated Jan 30, 200631.2k60100Article

The text of this article is not in this database — only its details are. The old site it was published on is gone, but the Internet Archive kept a copy: Accessing Excel Database using ADO.NET

6 Comments

Join the conversation! Your thoughts help the community grow.

swapna valmiki17y ago
Hi sir i want how to write code to convert Access data base to SQL data base using VB. Kindly please reply me sir.
Santanu Ghosh18y ago
Hello Sir. Can u know the code how to converting Excel Data to MSAccess .MDB in VB.NET , Plz help me [email protected]
- Mahesh Chand17y ago
  I am not sure how to do this besides doing it programmatically. You read Access data in code, and create a word document in code using Office Interop. To learn about Office Interop, click on the Office Interop link in the left side of home page of this site. You may want to look at VSTO (Visual Studio Tools for Office). This API allows you to work all kind of office documents.
guru19y ago
i have an excel file with so many colums. i have to insert these columns to an access database. pls give me any solution to solve this. anybody knows pls send to ---> [email protected]
- Mahesh Chand19y ago
  I don't have code for this but the way you can do is little complicated. You will have to connect to Excel file using ADO.NET (see ADO.NET section of this site) and read excel sheet data in a DataSet. After that you connect to Access database and update database with the data.
ravi buchingari19y ago
i am not able to parse more then 255 charecter into Excel database using c#.net . Please give me any solution to solve the problem..... Ravi [email protected]