Alright folks, I don't even know if this is possible, but I've been given a task at work which i would like to automate if possible. Basically, I have to: - Read .csv filenames from a windows folder - Correlate a known string from each filename to a set of (known) character strings - Create a table with that name in an Access database - Copy a bunch of cells from the csv file into the corresponding Access table (always the same cells in the csv files) Given that I have limited programming experience, and no windows scripting experiencing (though i have shell scripted in linux), can you recommend: 1) A tool to use for this? 2) Resources on this topic? 3) Method for how to do this? Thanks in advance for any of the above.|||1) Use access 2) http://www.bcschools.net/staff/AccessHelp.htm 1) Import the CSV file as a table and name it the filename. The cells will automatically be named the fields that are specified in the CSV header. If you need to link these imported tables with another master table, you can JOIN them with a simple query in access.

火车采集器