Accessing Excel Database using ADO.NET

Sign in to leave a comment.

• SV

  swapna valmiki17y agoPosted Nov 12, 2009, 2:23 AM

  Hi sir i want how to write code to convert Access data base to SQL data base using VB. Kindly please reply me sir.
• SG

  Santanu Ghosh18y agoPosted Mar 15, 2008, 12:50 PM

  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 agoPosted Apr 7, 2009, 10:16 PM

    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.
• G

  guru19y agoPosted Apr 26, 2007, 7:03 AM

  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 agoPosted Apr 27, 2007, 11:09 AM

    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.
• RB

  ravi buchingari19y agoPosted Jan 23, 2007, 12:59 AM

  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]