|I am working with a government system to extract data and export into Excel, then take one column and individually add this to an Access database. Here reports, statistics, and daily monitoring of cases happens. |
I would like to find a program that could use the excel data to import easy enough, rather than one at a time. We do approximately 5k cases annually.
I was told SQL might be a possible option.
I hope this was a little clearer in what I was looking for.
Thank you, Duncan