SQL Conversion

H

Henry

HI, is there an easy way to convert T-SQL to Jet-SQL? Perhaps some 3rd party
utility

Thanks
 
D

Douglas J. Steele

There aren't really that many differences. What specifically are you having
problems with?
 
H

Henry

Hi Doug, thanks for replying.

I have a very long sproc with unions and many joins, I'd like to insert the
script into a regular jet query, but I'm having syntax problems....likely
brackets. I do know that 'Left Outer Join' is not valid in Jet.
It would be nice if you could just transform SQL from one side (T-SQL) to
the other (Jet) and it would work.

Any thoughts.
Henry
 
Top