Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
insert into
Name: MAR Date: April 16, 2007 at 04:55:12 Pacific OS: XP CPU/Ram: 1.44 Product: Intel
Comment:
Hi guys need help to insert rows in a table from another table in MS Access. please post some sample. tks
Name: wizard-fred Date: April 17, 2007 at 10:25:27 Pacific
Reply:
In a database data is not inserted like a spreadsheet. Te displayed position is controlled by an index.
0
Response Number 2
Name: rousou Date: April 20, 2007 at 02:10:32 Pacific
Reply:
you can do this through an append query. create a new query in design view, select thr source table and then change the query from a select query to an append query. it will ask you the table that you wish to copy the data. then select fields you wish to copy (source and destination tables). you can also use the normal select queries functions such as filters, links etc.
Summary: Hi, I want to use a populate a table using a INSERT ... [INTO] tbl_name [(col_name,...)] SELECT ... structure. The thing here is that I want to have a order column, for example register 4, 1, ...
Summary: I have a empty table A that I am trying to populate. Insert into A(primary_key, Name) Select sequence.NEXTVAL, name From Table B The problem is that name in B have duplicate values and I cant use D...
Summary: Hey everyone, im taking an SQL class and im working on my first assignment. It seems simple but i keep getting an Error 1062, duplicate entry '1' for key 1. I have no idea what im doing wrong here. He...
0 
