 |
 |
 |
 |
 |
|
|
||||||||||||
|
|||||||
| Register | FAQ | Forum Rules | FAQ | Members List | Social Groups | Calendar | Search | Today's Posts | Mark Forums Read |
 |
|
|
Thread Tools | Rate Thread | Display Modes |
|
#1
01-06-2009, 02:18 PM
|
||||
|
||||
|
Running Update Query using a Table
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.
__________________
Where there is a will there are many ways. Pick One! Please read the Forum Rules If you are happy with any of the results, please add to the contributor's reputation by clicking the blue scales icon in the blue bar of the post. Please also mark the thread as Solved once it is solved. Check the FAQ's to see how. Last edited by NBVC; 01-08-2009 at 09:44 AM. 
|
|
#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]; When I run the query, though, it's says too many fields defined. When I click Help, it says I have more than 255 fields... but, in fact, I only have 132 fields. Does anyone have any ideas on how to get this done?
__________________
Where there is a will there are many ways. Pick One! Please read the Forum Rules If you are happy with any of the results, please add to the contributor's reputation by clicking the blue scales icon in the blue bar of the post. Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
|
|
#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?
__________________
Where there is a will there are many ways. Pick One! Please read the Forum Rules If you are happy with any of the results, please add to the contributor's reputation by clicking the blue scales icon in the blue bar of the post. Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
|
|
#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.
__________________
Where there is a will there are many ways. Pick One! Please read the Forum Rules If you are happy with any of the results, please add to the contributor's reputation by clicking the blue scales icon in the blue bar of the post. Please also mark the thread as Solved once it is solved. Check the FAQ's to see how. Last edited by NBVC; 01-06-2009 at 09:10 PM.
|
|
#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...
__________________
Where there is a will there are many ways. Pick One! Please read the Forum Rules If you are happy with any of the results, please add to the contributor's reputation by clicking the blue scales icon in the blue bar of the post. Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
|
|
| Bookmarks |
New topics in Access Tables & Databases
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
Linear Mode
