I need a very simple Access database created to hold a large number of contacts. It needs a total of 25 fields with room to add a few more. It only needs 2 views, list and detail view
It will need to have the ability to import records from csv or text files and to map the import to the correct fields. One feature I would like is upon import to have a dialog box ask me for the data source. I enter the source's name and the db would enter that info into the source field in the records that were just imported. Alternatively, upon choosing the file to import it would ask for the source and would add that info to the new data while importing it (whichever method is easier). The db should time and date stamp all data when it is imported into the db.
Finally it would need the ability to export the entire list or the just the results of custom searches into csv or delimited text files.
Looking to have this delivered ASAP.
I have a large number of contact files to import and my current raw data files total between 8-10GB. I have been advised by one of the bidders that since MS Access has a 2gb file size limitation, I would be better off by using MySQL. I am open to using MySQL as a solution to this problem