Link to home
Start Free TrialLog in
Avatar of MidWestGirl
MidWestGirl

asked on

Can Crstyal Reports Update Fields in an Access DataBase?

I currently have Crystal 2008 and Access 2010.  My database is from Access.
I need to be ablle to put values in 2 of the fields on the table. What would be the
best way to do this?
Avatar of Will
Will
Flag of United States of America image

either you can ODBC or you can directly link to Access. There is a choice for access/excel in the database expert for connection.
Avatar of MidWestGirl
MidWestGirl

ASKER

Yes I am connected to the access from Crystal. I created some formulas in crystal to change the
value of 2 fields. I need this to be a permanent change in the access table.
Does just setting the values in Crystal actually change it in the database?

sorry  Imissed your question about "update",  as far as I know cr is a view only you can export though.
yes I set it up to export to excel. I get 3 sheets created in the workbook. Don't know why this is.
you would have to likely export through ODBC
in an export through odbc to access I believe you will have o create a new table, so in essence you can update and replace an existing field in a data table.
I thought I could use SQL or some other language to do a write to the table. I go through the export report function. I did not see anything there for acess.
use odbc for the export
whoops wrong one


Picture1.jpg
ASKER CERTIFIED SOLUTION
Avatar of Will
Will
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Cool! Learned something new. hanks!
my pleasure