looking back over what i posted i can see where it makes for some confusion. here is some sample data:

table1:

10/1/2006 / Tammy / $200

10/4/2006 / Lisa / $300

table2:

10/2/2006...

Actually, the UNION is going to stack the results, which is not what I want. I want 1 row per date. So my final result would look like:

10/1/2006...

I guess i left off a critical piece of info... i'm using temp tables. I don't think UNION statements work on temp tables.

Well, the problem is can't guarantee that that value tit.tit_wfm will be non-zero. So i need to account for that condition. So one of my test cases is...

Actually, another question i had, and please excuse my ignorance, but can you do the same thing via the ActiveX task and bypass the Jet drivers altogether?  I'm just not...

Thanks,  appreciate the input greatly.  Unfortunately, the workaround reference is for flat files, not Excel.  So the "Max characters per delimited column" isn't relevant. 

is there no way around those limitations of 255 chars?

Ok, i have a new question... i'm using this ActiveX script in the DTS package to basically build a template report in a TXT file that can be generated automatically. ...

Thank you, gentlemen... both solutions worked for me. 

Appreciate that information.

Ray

That'll do it!  Thanks, Noel! 

The Journal table has a unique datetime stamp on each journal entry as well as a unique journal identifier called heatseq.

Thanks for the reply, Noel.  I tried your suggestion, however...