Thanks Peter Davis for your help, I added reference System.Data into my project. I'm using Xamarin Studio on MAC OS X 10.8. Do you using skype? If yes, please add me 'pakacoco'.
Hi Daltonj, I tryied in my side (office2010 32bit version on 64bit OS) and it seems no items in datasource wizards to select for Excel in Express version (Ultimate version containes it ODBC Data Source). So I’m afraid that you need to use it with the code. Hello, The following link goes along with what Mark wrote about which is a working example of accessing and updating some simple data.
An important thing to realize is that when working with a database such as MS-Access or SQL-Server your tables have a primary key which permits you to find a row of data by this key to use in locating data to update via SQL while Excel worksheets do not have a primary key generally speaking. The following article has a great deal of useful information and demo projects Sometimes working with OleDb needs assistance from Office automation, if you find yourself heading in this direction here is a resource KSG.
Hi Daltonj, I tryied in my side (office2010 32bit version on 64bit OS) and it seems no items in datasource wizards to select for Excel in Express version (Ultimate version containes it ODBC Data Source). So I’m afraid that you need to use it with the code. Hello, The following link goes along with what Mark wrote about which is a working example of accessing and updating some simple data. An important thing to realize is that when working with a database such as MS-Access or SQL-Server your tables have a primary key which permits you to find a row of data by this key to use in locating data to update via SQL while Excel worksheets do not have a primary key generally speaking.
The following article has a great deal of useful information and demo projects Sometimes working with OleDb needs assistance from Office automation, if you find yourself heading in this direction here is a resource KSG.