I currently have an Access database (accdb format) that is currently linked in GIS through an OLE DB connection. I have a groundwater analytical table with 36,000+ records that contains all of our site data. I would like to show concentrations for a small subset of these records in small tables (looks like a crosstab, see attached image) that apply to each individual well on the map.
Ideally I would like to run a query out of the access database to start the crosstab and use the Create Report function to parse out data from this query to plot individual data tables that will point to the corresponding well. Is there a way to do this at all, including using VBScript or Python? The whole point of this is to save time by having this done automatically rather than creating the individual tables in excel and then pasting them in as images.
أكثر...
Ideally I would like to run a query out of the access database to start the crosstab and use the Create Report function to parse out data from this query to plot individual data tables that will point to the corresponding well. Is there a way to do this at all, including using VBScript or Python? The whole point of this is to save time by having this done automatically rather than creating the individual tables in excel and then pasting them in as images.
أكثر...