Transfer data from one table to another

[YNWA]

I have created my tables, forms etc.. all sorted and working. Thanks to the people who helped me on here.

Now all I need to do is transfer stored data from a seperate database into my new one.

I have imported the table of data I require, but now I need to get it into my table.

How?

My table has different fields than the one I need to get data from, however I am not after everything, only generic data such as First Name, Last Name, Date of Birth, Address, Post code, telephone number.

Some fields in my table dont match the fields in the other table, which is a problem I feel.

What can be done to get data from one table to another, when table fields are sometimes different or are not relevant?

Cheers
Will

 

[jackmac]

Hi YNWA,

I've done this in the past - perhaps a two step process instead of one but it worked for me.

I imported the data into an Excel spreadsheet, cleaned it up so it was what I needed, then imported back into the new file in Access. That way, I had the fileds and required data and no extra rubbish.

Worth a try anyway.

Hope that helps...

Jack