Hi,

I hope somebody can help me?

I've got a macro that pulls data from an Excel sheet into a table. Everything works okay but I need some way of merging the data in two columns together.

For example

Column A Column B
932 12345678

Needs to be

Column A
93212345678

What's the best way of doing this? I'm still pretty new to Access so I haven't really got a clue!

Thanks in advance!

UPDATE MyTable
SET [Column C] = [Column A] & [Column B]

would do all the rows