Hi Ron,

I tried it, but it didn't work. I got an error message that says "This data
source contains no visible tables" right after I did the browse to the file
step.

AL


"AL" wrote:

Hi, I am trying to merge two sets of data into one using a one to many merge,
for example:
In column A, I have In column B, I have
100 101
200 102
300 103

my results column will look like:
100101
100102
100103
200101
200102
200103
300101
300102
300103

Any help would be appreciated.

AL