Crystal Report SQL Conversion

[Terry]

Does anyone know of instructions / utilities that would help me use a select
statement from a Crystal report in a MS Access Query?

We have several Crystal reports in my office, but I prefer Access. I can
pull the underlying select statement from the Crystal report and copy /
paste it into a MS Access query, but there are some differences in how the
select statement is written.

Thanks
Terry

 

[Bob Barrows]

Does anyone know of instructions / utilities that would help me use a
select statement from a Crystal report in a MS Access Query?

We have several Crystal reports in my office, but I prefer Access. I
can pull the underlying select statement from the Crystal report and
copy / paste it into a MS Access query, but there are some
differences in how the select statement is written.

No utilities. Crystal surrounds table and field names with "s instead of
[]s so you'll need to replace those. Other than that, it's a matter of
fixing issues as they arise. The ODBC driver (or Jet OLEDB provider)
typically takes care of translating the sql sent from Crystal into a
form that Jet will be able to tolerate.