Update access table to sql table
- From: Mark <Mark@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 13 Jun 2009 20:09:01 -0700
Hi all
Probably been answered before however i cant get a specific guide through
searches anywhere.
I Have an access table X it has 4million entries. Ive uploaded X to SQL as a
backend and linked it to my access db.
I create a temp table(Y) (only 2 columns) using data from X, do some calcs,
I then wish to update a new field in X lets call it 'Field1'. So when i
create an update query in access and innerjoin X to Y use its 2 primary keys
and try to update Field1 from temp table Y it takes about 30mins then bombs
out.
Anyway way to make this work and quicker?
I read that access loads the stuff into ram then trys to update the X table
in sql but i just dont understand why the query cant do it alot quicker.i
tried passthrough queries but that kept asking where is Y table.
if i append to sql table X it works fine but updating is the problem
any idea?
Mark
.
- Follow-Ups:
- Re: Update access table to sql table
- From: Piet Linden
- Re: Update access table to sql table
- Prev by Date: Re: Create a query
- Next by Date: Re: Create a query
- Previous by thread: date criteria or all
- Next by thread: Re: Update access table to sql table
- Index(es):
Relevant Pages
|
