473,226 Members | 1,701 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,226 software developers and data experts.

trying to copy a table to another with a second table as reference

1 need to copy the data in one table into another...but its from another database.
tables are demographics and testdata

database1 database2
demographics
personid personid same in both databases
eval eval same in both databases
autoid autoid different

testdata
autoid autoid
data1 data1
80 variables from database1 to database2
the autoid has me messed up
demographics1 demographics2
personid 1 personid 1
eval 1 eval 1
autoid 1 autoid 12

testdata1 testdata2
autoid 1 autoid 12
data1 4 data1
data2 6 data2
data3 9 data3
data4 3 data4

is there a way to copy the data in a quary ?
I put the 4 tables in a new database but I kept getting messed data.
thanks for any help
I thought this should be easy...maybe I made it tooooo hard

Jerry

Nov 12 '05 #1
4 2014
Why don't you use the Import wizard and then create an Append Query to append
the data to the new table?

File, Import, select the db, import the table(s). Go to queries, select query,
select the table, go to type query and select append, select the table and
fields and append. If the data in both tables is the same it should work
flawlessly.

HTH

Michael
Nov 12 '05 #2
the problem is I can import and append but
the autoid numbers are different in both databases
they created personid and eval period
in both databases ....this made the 2 databases the same...or almost
the autoid in database1 is different than the autoid in database2
so I have 2 tables that are linked to the demographics table by an autoid
and they are not the same.
personid and eval same but not the autoid
demographics
personid SAME
eval SAME

datatabes
autoid DIFFERENT

so
personid 1 eval 1 autoid 1 database1
personid 1 eval 1 autoid 100 database2

how do I copy the autoid1 to the new table with autoid 100
On 01 May 2004 10:30:39 GMT, lu*************@aol.com (Lumpierbritches) wrote:
Why don't you use the Import wizard and then create an Append Query to append
the data to the new table?

File, Import, select the db, import the table(s). Go to queries, select query,
select the table, go to type query and select append, select the table and
fields and append. If the data in both tables is the same it should work
flawlessly.

HTH

Michael


Nov 12 '05 #3
sparks wrote:
1 need to copy the data in one table into another...but its from another database.
tables are demographics and testdata

database1 database2
demographics
personid personid same in both databases
eval eval same in both databases
autoid autoid different

testdata
autoid autoid
data1 data1
80 variables from database1 to database2
the autoid has me messed up
demographics1 demographics2
personid 1 personid 1
eval 1 eval 1
autoid 1 autoid 12

testdata1 testdata2
autoid 1 autoid 12
data1 4 data1
data2 6 data2
data3 9 data3
data4 3 data4

is there a way to copy the data in a quary ?
I put the 4 tables in a new database but I kept getting messed data.
thanks for any help
I thought this should be easy...maybe I made it tooooo hard

Jerry

Maybe consider 2 fields; AutoID and ImportID. First update all
ImportIDs to the AutoID field in the production table. Then when you
append, store the AutoID in the ImportID field.

Nov 12 '05 #4
well it seems that every time I dropped a table into the quary it
linked it to the wrong table---was linking it to a quary but it kept
going back to the table.
Got that fixed and everything is working now.

Thanks for tip on the idea to build another variable to hold the
autonumber.
that is where I saw it was looking at the wrong input.
And it also made it a lot easier to do than the way I was doing it.

thanks again
jerry

Nov 12 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: cv | last post by:
Hi all, I have to copy two set of data from 2 files(notepad/excel) say, products and their corresponding prices to list/textarea/table. I should be able to retrieve the product and corresponding...
42
by: Edward Diener | last post by:
Coming from the C++ world I can not understand the reason why copy constructors are not used in the .NET framework. A copy constructor creates an object from a copy of another object of the same...
2
by: Top Gun | last post by:
Is there an easy way to do this?
5
by: Tony Johansson | last post by:
Hello! I'm reading in a book about C++ and that is something that sound strange. It says "Pointers have reference-assignment semantics similar to those in Java. For example, after the...
7
by: Wolfgang Kreuzer | last post by:
Hello all, I have two tables - Projects and ProjectStruct Table Projects contains master records of the projects, ProjectStruct allows to define a project herarchie and contains the fields...
4
by: sparks | last post by:
1 need to copy the data in one table into another...but its from another database. tables are demographics and testdata database1 database2 demographics personid personid same...
4
by: fperfect13 | last post by:
Hi, I wanted to perform a deep copy of an array. Searching on google I ran into different opinions : C# Interview Questions (http://blogs.wwwcoder.com/tsvmadhav/archive/2005/04/08/2882.aspx)...
3
by: Jul | last post by:
Hi, I need to create copy (clone) the OracleConnection object. The OracleConnection class does not contain "Clone" method for creating copy. It contains Protected MemberwiseClone but if use...
76
MMcCarthy
by: MMcCarthy | last post by:
Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.