I start creating the attached access db to simplify the data entry process currently done using Excel. We also purchased a third party application (for data definition purposes) that allows us to import what we already have in place. But, in order to export to the third party application:
1. It’s limited to 10 fields
2. The file has to be in CSV format
Since we’re limited to 10 fields, we currently input multiple fields in a single cell and use save as CSV for export.
What design changes do I need to make in Access to include everything I have in my (frmDataEntry2) so I can create a report that I can export as CSV?