Copying data from one table to another

[DSCartwright]

Hi, thanks for looking at my query.

I want to be able to copy the data within a selected field and then place it into a fresh database is this easily done?

my second questions is i have several fields which need to be merged into one 'Address' field as currently i have data with Building Name, Number, Line1, Line2, Line3, County, Town, Country. This is required to be merged into one field how would i do this?
Not all fields have data is there a way to put a space between each of the current fields when merged as well?

Kind regards.

Damien

 

[RainLover]

In Access 2003 under File there is an import Wizard. You could use that to copy the Data from one Database to another. If this is not a one off situation then you will need to do this in VBA. Post Back with more info if required.

Part two of your Question. The way the Data is stored now is best. This way you can search or sort by any field.

You can always join them when required.

 

[DSCartwright]

This will be a one off move, the data has been refined from an existing database i want to move this information permanently from one database to another but moving it into new fields.

The join is required as this will also be permanent as the address is just one field in the new database.

Regards

 

[RainLover]

The join is required as this will also be permanent as the address is just one field in the new database.

Are you sure about this. It is really a BAD move.
It would be so much better if you create additional fields in your new Database.
You could then join them in a query if you wanted.
Have a think about how difficult this is going to be to display the Country on a separate line.

If you still want to do this then Google for Concatenation.

Sorry but I don't fell right giving out bad advice. Hope you understand.

An easier way to import is to link to the source Table. Then using the query builder you can create an append query. If you have problems look at the Help files for examples and detailed instructions.

 

[DSCartwright]

I understand your concern but this is being move from one existing system into another existing system and the way data is stored is very different and there will be no need for individual address lines once done.

 

[RainLover]

The method as I said is Concatenation. Google it for more details.

Essentially it is

[Field1] & " " & [Field2] & [Field3]

There will be a few spaces between 1 and 2 and no spaces between 2 and 3.

Very simple. There are other Bells and whistles you can discover in your searches. Too many for me to remember to a point where I could give you them all. But then to think about it I would not know them all off the top of my head.

 

[DSCartwright]

You're a good man my friend. Thank you very much.

 

[RainLover]

I must go on record by saying,

One Day you will regret this.