Importing data

[yoavchen]

how can i import data to an access db from another access db? i need only the data, and not the tables, only what inside the tables.
DB-A: all table are full
DB-B: the tables and the realationships are exist but the tables are EMPTY.

i need to import the information from DB-A tables to DB-B tables, without copyig the tables.

 

[KenHigg]

Have you tried linking to the tables then do an append query?

kh

 

[yoavchen]

no

no i haven't , can you explain to me how to do that and what does it do (means)

Thnaks

 

[MarkK]

Open db-B.
Click main menu: File->Get External Data->Link Tables.
Select db-A in file selection dialog.
Select tables to link.

Linked tables work just like local ones, so now you can write queries on your old tables to make new ones.

 

[yoavchen]

okay i did it

but now the problem is that before the linking i had 4 table and now i have 8. ill explain:
i had(before the importing) the tables: workers,managers,salaries and summaries, which all was empty from data.

now i got all the tables before PLUS: workers1,managers1,salaries1 and summaries1, which all full of data from the DB-A.

Te prblem that i want to import ONLY THE DATA that inside DB-A, and not the tables themself...

do you know what i mean?

 

[stepone]

now i got all the tables before PLUS: workers1,managers1,salaries1 and summaries1, which all full of data from the DB-A.

What you need to do now is write an append query to copy the data from workers1 into workers, and from managers1 into managers, etc, etc.

You can then delete the linked tables (all those ending in '1').

Cheers,
StepOne

 

[KenHigg]

Do you know how to do an append query?

kh

 

[yoavchen]

i did...

but now it gives me this error:

"Microsoft access can't appand all the records in this append query

Access set 0 field(s) to null due to type conversion failure, and did not add 6 record(s) to the table due to key violations, 0 record(s) due to lock violations, 0 record(s) due to validation rule violations.
do you want to run the action query anyway?
To ignore the error (s) and run the query click yes"

and then i looked of the managers table which supposed to be full and it didnt.

What's wrong with it?

 

[KenHigg]

How many records were you trying to append?

kh

 

[yoavchen]

6 records

in the managers1

 

[MarkK]

Check that all source and destination fields are of the same type.

 

[KenHigg]

Aside from the append problem, I'm confused. I thought you said the original table were full(?). Come to think of it, even if this was the case, if you did bring 'em all over, won't you be back to the original size problem?

kh

 

[yoavchen]

okay...

let me try to explain my problem a little more. let's call the full database DB-A
and the empty database DB-B.
now, DB-A and DB-B are two database that the different between them is that DB-A has records in his tables, and DB-B has not. everything else is the same,tables (without the data ofcourse,forms,macros...).
i want to have the ability to copy only the data from DB-A tables into DB-B empty tables, only the data, not the tables not the tables nemes....only the records.

the reason i am trying to do so is that i want 2 versions, DB-A calls 'development' and DB-B that calls 'production'

My boss want to work with the production.mdb dayli. now, when he want to change somthing in the database(forms,fields est.) he want me to do it on the development.mdb so i won't see all the data in the tables. now, after ill change what he asked me to, i want to take the data from the production.mdb and import it to my development.mdb which i have made the changes. now, i will give him the development.mdb and it will become the new production.mdb, the old production.mdb will be erase. before ill import the data, i will make a copy of the development so i will have a copy of the development that are going to become a production.mdb..

well, thats it, i really hope i made my story clear enough....
Thanks for the patience...

 

[KenHigg]

Hum...

How about this:

1. Your production database needs to be split into to a front end and a back end. The front end has the forms, queries, etc. The back end has the tables.

2. For development, you have an exact copy of this set up on your personal workstation.

3. If you do changes to the front end stuff, you redistribute the fe db.

4. If you need to modify the backend data, you need to get everyone to exit the db while you do the modifications.

At least this is the way I do it, and it work pretty good. I sure others have variations to this methodology...

Is all this possible in your situation?

kh

 

[TheEvilBankers]

If you don't want to split the database.

Just copy the db to a different folder or drive. Rename the thing and just delete what you don't need or want.

Leave the tables you need and go from there.

Far easier I think than what you have been trying to do.

I would split the database if you are going to have things changing names and moving around, a mistake will happen if you do it the way you are talking about coping dbs over existing ones.

K

 

[yoavchen]

but if i will split the db, it is not helping me to develop without seeing the data, if i need to add another field to the manager's table, i have to go to the back end file, where all the data there, get inside the table and then add the field. i can see all the data inside the table, i didnt achieve anything, the data is not secured.
i need a solution that i will develop the development.mdb and thean my boss, with one click will be able to upload all the data by himself.

if you want me to add the file i will, just tell me

Thanks

 

[TheEvilBankers]

Okay stupid question time...

How do you develop without seeing the data?

Is it items that are considered private in nature like managment reviews?

You are going to need some data to build forms, queries and reports. So why wouldn't you want to see the data?

K

 

[yoavchen]

i can't see the data cause my boss dont want me to see....it's confidential,options, agreements and stuff...
i can develop with an exapmle data that i will insert manually each time i have to develop somthing...

 

[TheEvilBankers]

Make a copy of the database somewhere, rename it and then just delete what you don't need from it.

It is going to be the quickest way.

K

 

[yoavchen]

I didnt understand how this way will solve my problem to ipmort the data , that i am not supposed to see?