Afternoon,
I am unsure if this is the correct place for this or not. If not I do apologize and will not waste your time;
I have used access a long time ago and forgotten it.
I attempted to due what I was looking for in excel but it has limitations on records.
What I have is csv files being generated automatically 5 times a day. In each file there is approx 3000-5000 records.
What I am trying to do is compile all this data into 1 database so that it is searchable. I currently have data going back to Nov 2014.
When we complete a search in the database, for every time it finds the searched item, it produces an output that shows the entire row.
I have attached two csv files for example.
Thank you in advance if I receive help and thank you if I don't and this is the incorrect forum.
Appreciate all.Call_Records.zip