Hello,



I have a big problem that I am trying to solve with no luck!

I am using Excel to connect to my company oracle database by using ODBC, and
programming SQL lines to determine conditions.

My problem is that I am trying to use the function CONCATENATE to string my
database (not working in SQL) so my last option is to generate Macro program
to do the Job (my data is very large).

Here is actually what I am trying to do



Result

Data Base

Optio Code
Car Code

Optio Code
Car Code

256,252,115,111,110
F7020

110
F7020




111
F7020




115
F7020




252
F7020




256
F7020








Any suggestions ???????????





Oren