HELP :confused:

Hi,

I need to copy 5 columns in an Access table into a single column in Excel. How can I do this?

Pictures To Help explain below:

http://uploads.savefile.com/users/uploads/1_154.jpg 261kb
http://uploads.savefile.com/users/uploads/2_154.jpg 192kb

I would do a quick and dirty query to concatenate them. Then copy that.

kh

create a new field in your query, and put the following:

=[House Number] & " " & [Street] & " " & [Town] & " " & [Country] & " " & [PostCode]

eventually, you should replace the above with the correct names of your fields ... eventually, you can just copy and paste this newly created field, in you excel worksheet.

Thanks maxmangion that done it thanks

:D :D

you're welcome :)