We manage over 1 million rows of data in Excel, mostly csv files. I want to find a solution to have all data in one database and be able to extract data, by state mostly, that will be saved to separate csv file.
What software package, cloud based or other method would be best?
I need a solid recommendation. Please provide your advice.
I have used a script within Excel and it doesn't work. Plus Access has a limitation on rows of data... I have over 1.5 million rows. The solution should be not Excel or Access. Thanks!
39 威客就此工作平均出价 $38
This problem my be solved with the help of R-script or any else. the files are putted in one folder, then the script read the list of filenames, then it loops reading the files and row binding them in one table.
Hello Sir, IN my team i have 8 yr+ Experience Excel, VBA, Micro Developer. he can develop a Micro for your task. i want your requirement in details. For more discussion feel free to chat .