Pulling data from a data warehouse using Crystal Reports; then exporting the data from the report into Microsoft Access. When I do that the field lengths change. I would like to keep the field length from the Crystal Report. Any ideas on how I can do that?
I'm creating a new table every time because Crystal Reports won't let me import into the existing table. I get the error message "Table already exists. Please use another table name or you can retry after removing the current table."
I am creating a report using Crystal Reports and then exporting to a new table in my Access database. I then fix the field names (They are very long field names in Crystal, and Access cuts them off. I cannot change the field name in Crystal.), delete the old table, rename the new table to the old table name, and re-establish the relationships.