Help with Import a Table Data

[heman85]

Hello
I have a Employee Table with 100 record. The Fields in that table are:

Name(Text)
Emp Number(Number)
Phone(Number)

I create a new Employee Table and I add some new fiels like

Current Status (Yes/No)
Emergency Phone(Number)

Now my Employee Table looks like this:
Name (Text)
Emp Number (Number)
Phone(Number)
Current Status (Yes/No)
Emergency Phone(Number)

How can I transfer all the original Employee Table and add those 100 record without loose any data. I set the Current Status Yes by Default.
If the new Emergency Phone field come blank its not a problem.

I try with txt file But Receive error. HELP PLS

 

[CameronM]

Are the two tables in the same database? If so, simply create a new query, set the query type to Append and choose your new table. Then you simply select the fields from your original Employee table and since they are named the same you should find that Access will automatically do the field matching for you.

 

[heman85]

Are the two tables in the same database? If so, simply create a new query, set the query type to Append and choose your new table. Then you simply select the fields from your original Employee table and since they are named the same you should find that Access will automatically do the field matching for you.

The tables are in two differents DB.
Thanks

 

[Rabbie]

You could use an Append query to add the old data to your new table. See Access help for more info

 

[heman85]

You could use an Append query to add the old data to your new table. See Access help for more info

Im gonna try this and I tell you the results. Thanks for help me.

 

[heman85]

you Could Use An Append Query To Add The Old Data To Your New Table. See Access Help For More Info

Man Its Working Great
Thanks Very Much For Your Help
Thank You Thanks You