Monthly Archives: May 2018

MS Access Function – import all CSV files from a directory with the same structure into a single table

This is a really nice function that can be used to place all data from multiple CSVs (with the same structure) into a single table. Here I use the Ordnance Survey’s excellent Code Point data set that gives postcodes in … Continue reading

Posted in Address Matching, All, Geographical Information Systems, GIS, MS Access, Open Source, VBA Code MS Access | Comments Off on MS Access Function – import all CSV files from a directory with the same structure into a single table

MS Access Function – Scan through a directory and write list of files to a table

Pretty much as the title Ensure you have a table called tblFiles with one field called Filename Here I am finding all files in folderspec = “C:\Users\Mark\Documents\CodePoint\Data\CSV” Alter as appropriate Function ShowFolderList() Dim fs, f, f1, fc, s Dim rs … Continue reading

Posted in All, MS Access, VBA Code MS Access | Comments Off on MS Access Function – Scan through a directory and write list of files to a table