Hey guys,

I got a question about concatenate() function. I have an excel wooksheet which has 2 fields that I want to combine and transport it into access database. For Example:

Column 1 Column 2
22 001
22 002
22 010
33 011
55 051
66 101
77 110
88 210



My question is what is the easiest and most efficient of concatenating it? Currently, I have the 2 columns as text so I can have the leading zeros if necessary.

The "&" symbol in Access truncates the leading zeros. So, I tried by sticking "0" in the middle, but access is dropping the trailing number in the ends.

I was looking at excel about Concatenate() function. I took the relevent columns and made a seperate sheet. The third column would have the concatenated field. I thought it was simple plugging in the cells that I wanted to concatenate. But it is only displaying the function(formula) and NOT the answer. Note: I have both columns as text to display the leading zeros.

Any Solutions?

Thanxs in advance ,

Manoj