How to Import multiple Excel CSV data files into a database daily without overwriting current data

[Rossovich]

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

[pbaldy]

I'm unclear what the question is. You should be able to append records from each file into the same table, and leave previously imported data alone. Are you not able to?

[ssanfu]

I agree with Paul, what is the question? What have you tried?

Because of the date in the first line and the 3 "header lines", I think you will probably need to use VBA to import the CSV files. And you could import all of the files in a folder.