Update Query

[SHAWTY721]

Hi I was wondering is there a way to update a field in an excel spreadsheet, like can be done using the update query in access. I have a spreadsheet that contains a column that has a couple values that need to be updated to the new account number so it can the values can be linked between spreadsheets.

 

[SkipVought]

Hi,

Have you tried linking the sheet as a table and performing your update?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

Actually it's linking the WORKBOOK, which makes all sheets as tables.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SHAWTY721]

I have tried to update the linked table but it will not let me in Access. So that is why I am trying to find a way to do it in Excel. Since I did not create the database and I am just working on keeping it up to date and creating things from the database.

 

[SkipVought]

"I have tried to update the linked table but it will not let me in Access."

Really? I am able to perform such an update. Just did in a test database with a linked Excel workbook!!!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}