0

I am trying to read all record from MS access database using automation(using Microsoft.Office.Interop.Access) in C#.

I able to read record using ADO.net in C# but not using Automation.

Please help.. Thanks

Kapil Khandelwal
  • 15,958
  • 2
  • 45
  • 52
Champat
  • 1
  • You will need to do quite a lot of reading and then come back here with some code and notes on where you are stuck. Under the following search http://stackoverflow.com/search?q=interop+%5Bc%23%5D+%5Bms-access%5D you will find quite a lot on Access and C#, for example http://stackoverflow.com/questions/9909644/how-can-i-extract-an-mdb-files-table-contents-to-text-in-c, this will give you key words to find articles both here and through googling. – Fionnuala Nov 20 '12 at 11:23
  • Thanks,Remou provided links works for me.Thanks a lot. – Champat Nov 21 '12 at 04:54

1 Answers1

2

Unless you have a specific need to involve the Access user interface in this task, I recommend you don't do this. Instead, use OdbcConnection or OleDbConnection to directly access and manipulate the database.

tomfanning
  • 9,552
  • 4
  • 50
  • 78