need help exporting from Crystal Reports to Access

  • Thread starter Thread starter doug access-crystal
  • Start date Start date
D

doug access-crystal

I am trying to export a report from Crystal Reports to
Access using ODBC. I create a report in Crystal Reports
and save it. I create a blank database in Access and
save it. I close Access. In Crystal Reports I go to
export, chose ODBC - Microsoft Access Database, chose OK,
select blank database and accept the default table name
CREXPORT, which does not exist. It fails and tells me
the reason why is because "field 'DE_' already exists in
table CREXPORT". I have tried different table names and
nothing helps. Is there anyone who can tell me why it is
doing this and what I can do to fix it?

Thanks, Doug
 
Solved!
Report had a field named "Form No.". Access ODBC did not
like this name. When I called it "Test" the problem went
away.
 
Back
Top