I came across this same problem with Access and Visual Studio. Visual Studio does not support read and writes in its Adapter to Oledb. Its not bi-directional. Just read only. I know its a major pain. Its the last thing I expected also. I suppose it forces you to use Sqlserver. There are other sources out there for MySql and some other databases but you may not have time.

You have a couple choices here. If available switch to...

What you may be looking for is Office Automation through Visual Studio. You need the Primary Interop Assemblies installed for either 2003 or 2005 Office. You then can control Word, Excel, Access and others programmaticall y through VB.net or C#.Net. Thier are downloads and programming examples online through Microsoft.

Good Luck,

TracyM

Try using the Office Primary Interop Assemblies. You can get full automation control over Excel or other office app's for that matter. I used this to manipulate Excel files, Access files and finally Visio files and integrating all of them through a vb.net interface. Works nicely. You can download the interop assemblies for 2003 or 2005 for free.

For my needs I moved the Excel Data into an Access Table, Made a DataAdapter Connection,...