Inserting data in new colums

[wasim_sono]

Dear All

I have a master table with data. after two months I need to insert three new colums in this table. I inserted. The table has 1500 records. I inserted data of new colums in another table. both tables have same uniue field of 'EMP NO'. Now how I enter this data in to my master table? either run an update query or append query or some thing new.

Thanks.



Wasim

[Windows]

this is off the top of my head, but you "should" in theory be able to an update query, sql would be similair to this:

insert into <table name here> column1, coluhm2, etc, where emp no.table1 name = emp no.table name

i don't think an update query has to have the two tables match exactly, ie the columns must be exact, like if you were importing new information, and the join might need to be revesed, ie it might be emp no.table name = emp no.table1 name, again this is off the top of my head, as i am at work, hope this helps, and if not i can look in my books, or perhaps matthewspatrick could assist, he seems to be a wiz at access and answers all questions asked here.

[wasim_sono]

Thanks for the reply. sorry for my words that they flew over ur head. :shock:

I tried insert command but it gives syntax error at colum1. Have any other idea? I hope mathew will reply me If he look it.


Wasim