|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
September 13th, 2003, 04:58 PM
|
|||
|
|||
|
Update using SQL in Access
I'm trying to update a table in MS Access using a sql script. The statement is:
UPDATE name_info SET mkey = mkey$ WHERE id_number = idnum$; The values for mkey$ and idnum$ were taken from a text file and using VB, I've generated a script for about 6,000 records but cannot run it in Access for some reason. It is too time intensive to run each UPDATE query individually. Does anyone know a way to run the whole script at once to update all 6,000 records in one go?
|
|
#3
September 14th, 2003, 02:28 PM
|
||||
|
||||
|
yes, import your changes into a new table, then do a joined update --
Code:
update name_info set mkey = name_info_updates.mkey from name_info , name_info_updates where name_info.id_number = name_info_updates.id_number ... or something like that (sorry, i cannot test it today) rudy http://r937.com/
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Update using SQL in Access |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
