cancel
Showing results for 
Search instead for 
Did you mean: 

IMPORTING QUERIES FROM ACCESS?

Former Member
0 Kudos

Post Author: Mike27

CA Forum: Data Connectivity and SQL

Just wondering if someone could let me know what are the factors that

allow a query from access to be successfully 'imported' and used in

crystal reports xi... for example I ve noticed that crystal reports

does not like acess queries with a paramter value look up function in

them... when you try to import such a query an error message appears ..

Data parameters.... Anyway all help regarding this matter would be

greatly appreciated. Cheers.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Post Author: V361

CA Forum: Data Connectivity and SQL

Try copying the query in access, then remove the parameters, copy and paste the sql into CR, and then use CR's parameter functions to rebuild the access parameters that you have removed.