Crystal Report SQL Conversion

  • Thread starter Thread starter Terry
  • Start date Start date
T

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
 
Terry said:
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.
Click to expand...
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.
 
Back
Top