OLEDB update to Access from Excel

Question

I am using MS Excel 2007 and have incorporated an OLEDB linked table from MS Access on a worksheet, the data from the Access table shows in the worksheet and i'm able to query the contents.

The connection string is as follows;

Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\MS Access\OSData.mdb;Mode=ReadWrite;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;Jet OLEDB:Support Complex Data=False

I would like to be able to update the data from the MS Excel Worksheet, however if i overtype one of the cells with revised data and refresh, the original data is shown.  I've changed the connection string (above) to Mode=ReadWrite thinking this was the issue, however this has not worked.

Am i able to update the underlying table data in MS Access through the OLEDB worksheet?  If so could you provide some suggestions.  Many thanks.

Answer 1

Has anyone got any ideas about this?

Answer 2

Ask your question here:

http://answers.microsoft.com/en-us/office/forum/customize?page=1&tab=no&mod=NoReplies