[SOLVED] Running Update Query using a Table

NBVC · #1 01-06-2009, 02:18 PM

Hi,

I am trying to run an "Update Query".

I want to use a table I imported from Excel.

The table includes Part Numbers and related data.

I want to update my Company's database by finding those Part ID's in my table and updating all other fields with new data.

Thanks again.

NBVC · #2 01-06-2009, 02:48 PM

Ok I think I figured out how to construct the query:

Code:

UPDATE ElectricalParts INNER JOIN [SYSADM_PART - Sandbox] ON ElectricalParts.ID = [SYSADM_PART - Sandbox].ID 
SET [SYSADM_PART - Sandbox].DESCRIPTION = [ElectricalParts].[Description], 
[SYSADM_PART - Sandbox].STOCK_UM = [ElectricalParts].[STOCK_UM],

...(more of similar code)

[SYSADM_PART - Sandbox].IS_KIT = [ElectricalParts].[IS_KIT];

NBVC · #3 01-06-2009, 04:09 PM

Well I kind of partly solved it by splitting up the table... so I will Update half the fields first, then the other half after....

Now I get no errors, but it now asks me for a parameter for Description, which is the first field to update...

Why is it asking this?

NBVC · #4 01-06-2009, 09:04 PM

I thought perhaps the square brackets where where causing the Parameter inputboxes to come up.. (like in MSQuery) but that didn't fix it either...

I crossposted this at http://www.access-programmers.co.uk/...255#post792255 since I have had no luck here and need to resolve this.

NBVC · #5 01-08-2009, 09:44 AM

In case anyone is interested... this one has now been solved at Access World Forums in the link in previous post.

It was a stupid thing.. the dash (-) in my table name seems to have caused the problem..even though someone in the thread tried it on his own with a dash and it worked for him...

Welcome to the Excel Forum

Forum Statistics