Update fields in linked Excel - Cannot update (Error 3113)

[Guest]

I was using Access97 & now have 2003 installed. I’ve converted my 97 DB’s to
2003.

All of the Update Queries that update fields in linked excel spreadsheets do
not work. I get the following error message. “Cannot update ‘(expression)’;
field not updateable (Error 3113)â€.

To test the query, I imported the excel spreadsheet as a table with the same
name. 2003 will update the imported table, but will not update a linked
spreadsheet. Is there something on 2003 that may not be installed on my
computer?

Here is a test SQL that works on Access97, but not 2003.
UPDATE update_test INNER JOIN [DIV 1] ON update_test.ITEMNO = [DIV 1].ITEMNO
SET update_test.COST = [DIV 1]![COST];

 

[Guest]

I can't find the exact reference, but Microsoft lost a lawsuit and was
required to remove that capability. You can no longer update excel files
linked as tables.
The only option is to use automation.

 

[Guest]

My previous post wasn't complete. The other work around would be to import
the spreadsheet, do your updates in the table, then export the data back to
excel.

 

[Guest]

What do you mean by "automation"? Importing the spreadsheet to a table is a
manual process.
--
Thanks, Kevin

I can't find the exact reference, but Microsoft lost a lawsuit and was
required to remove that capability. You can no longer update excel files
linked as tables.
The only option is to use automation.

I was using Access97 & now have 2003 installed. I’ve converted my 97 DB’s to
2003.

All of the Update Queries that update fields in linked excel spreadsheets do
not work. I get the following error message. “Cannot update ‘(expression)’;
field not updateable (Error 3113)â€.

To test the query, I imported the excel spreadsheet as a table with the same
name. 2003 will update the imported table, but will not update a linked
spreadsheet. Is there something on 2003 that may not be installed on my
computer?

Here is a test SQL that works on Access97, but not 2003.
UPDATE update_test INNER JOIN [DIV 1] ON update_test.ITEMNO = [DIV 1].ITEMNO
SET update_test.COST = [DIV 1]![COST];

 

[Guest]

What do you mean by "automation"? Importing the spreadsheet to a table is a
manual process.
--
Thanks, Kevin

My previous post wasn't complete. The other work around would be to import
the spreadsheet, do your updates in the table, then export the data back to
excel.

I was using Access97 & now have 2003 installed. I’ve converted my 97 DB’s to
2003.

All of the Update Queries that update fields in linked excel spreadsheets do
not work. I get the following error message. “Cannot update ‘(expression)’;
field not updateable (Error 3113)â€.

To test the query, I imported the excel spreadsheet as a table with the same
name. 2003 will update the imported table, but will not update a linked
spreadsheet. Is there something on 2003 that may not be installed on my
computer?

Here is a test SQL that works on Access97, but not 2003.
UPDATE update_test INNER JOIN [DIV 1] ON update_test.ITEMNO = [DIV 1].ITEMNO
SET update_test.COST = [DIV 1]![COST];

 

[Guest]

Automation is opening an Excel spreadsheet as an object in Access and
manipulating it using VBA. See GetObject or CreateObject in VBA help for
more info.

What do you mean by "automation"? Importing the spreadsheet to a table is a
manual process.
--
Thanks, Kevin

My previous post wasn't complete. The other work around would be to import
the spreadsheet, do your updates in the table, then export the data back to
excel.

I was using Access97 & now have 2003 installed. I’ve converted my 97 DB’s to
2003.

All of the Update Queries that update fields in linked excel spreadsheets do
not work. I get the following error message. “Cannot update ‘(expression)’;
field not updateable (Error 3113)â€.

To test the query, I imported the excel spreadsheet as a table with the same
name. 2003 will update the imported table, but will not update a linked
spreadsheet. Is there something on 2003 that may not be installed on my
computer?

Here is a test SQL that works on Access97, but not 2003.
UPDATE update_test INNER JOIN [DIV 1] ON update_test.ITEMNO = [DIV 1].ITEMNO
SET update_test.COST = [DIV 1]![COST];

 

[Guest]

Why is ne of my colleagues is able to run my converted DB with the Excel
update query on his machine from my network folder. He also has Access 2003
on his machine. The only difference is the versions.

Mine: (##..####.8036) SP2
His: (##.####.5606)

--
Thanks, Kevin

I can't find the exact reference, but Microsoft lost a lawsuit and was
required to remove that capability. You can no longer update excel files
linked as tables.
The only option is to use automation.

I was using Access97 & now have 2003 installed. I’ve converted my 97 DB’s to
2003.

All of the Update Queries that update fields in linked excel spreadsheets do
not work. I get the following error message. “Cannot update ‘(expression)’;
field not updateable (Error 3113)â€.

To test the query, I imported the excel spreadsheet as a table with the same
name. 2003 will update the imported table, but will not update a linked
spreadsheet. Is there something on 2003 that may not be installed on my
computer?

Here is a test SQL that works on Access97, but not 2003.
UPDATE update_test INNER JOIN [DIV 1] ON update_test.ITEMNO = [DIV 1].ITEMNO
SET update_test.COST = [DIV 1]![COST];

 

[Guest]

That is when this changed happend, with SP2. Once he has SP2, he will have
the same problem.

Why is ne of my colleagues is able to run my converted DB with the Excel
update query on his machine from my network folder. He also has Access 2003
on his machine. The only difference is the versions.

Mine: (##..####.8036) SP2
His: (##.####.5606)

--
Thanks, Kevin

I can't find the exact reference, but Microsoft lost a lawsuit and was
required to remove that capability. You can no longer update excel files
linked as tables.
The only option is to use automation.

I was using Access97 & now have 2003 installed. I’ve converted my 97 DB’s to
2003.

All of the Update Queries that update fields in linked excel spreadsheets do
not work. I get the following error message. “Cannot update ‘(expression)’;
field not updateable (Error 3113)â€.

To test the query, I imported the excel spreadsheet as a table with the same
name. 2003 will update the imported table, but will not update a linked
spreadsheet. Is there something on 2003 that may not be installed on my
computer?

Here is a test SQL that works on Access97, but not 2003.
UPDATE update_test INNER JOIN [DIV 1] ON update_test.ITEMNO = [DIV 1].ITEMNO
SET update_test.COST = [DIV 1]![COST];