write to access from report

[ajdesigns]

Is there any way that I can setup a 1 page report(pallet statement) and write the data entered to an access database.I need to use parameter fields to promt the user to enter a lotno, product code etc I then want the data entered to be written back to the corresponding access database.

 

[lupins46]

No.
I think the closest you can get is to output the data to Excel and then use Access to update its records with the data in the workbook. If you have V9 then you can output data only which would be a better data source for access.

 

[GMcNamara]

Crystal 9 uses real SQL so you could write a report using an SQL Command that contains an INSERT statement.