All:
Client has an excell spreadsheet with a large volume of data:
Greater Than 100 columns
Greater Than 13000 rows
Currenlty client has a need to identify approximately 5 fields for any given record based on a search criteria and then report that data to another location.
At this point client has been using simple excel search to identify the record and copy the fields needed.
Client would like to instead present the data to staff to allow them to search records.
Problems:
Data should be secured to prevent unintended changes (read-only)
Staff search should be on only the necessary fields and not distracted by the remaining volume.
Cannot currently use Access -- Staff does not have the right version of office.
Uncertain MySQL will deploy correctly to thier environment or that there is sufficent time to "develop"
Attempted to apply a simple excel form however volume of data causes error:
Too Many Fields In The Data Form
If nececssary will likely employ MySQL as quickly as possible, however thought I would as the question here to find out if there was an option I was overlooking.
Thank you in advance for all input and suggestions.
Bookmarks