Search results

Hello, I received a database with many tables that are by year and region, with identical layouts. For example, tblRegionA2001 tblRegionA2002 tblRegionA2003 tblRegionB2001 tblRegionB2002 tblRegionB2003 I'd like to combine these in a way that I can use a pivot table to summarize the data in...

Hi, I have a large numbers of text files I'm sent regularly as they are changed/updated. I import them and replace the old ones, run some queries that are already written in Access and produce what I need. I was trying to find something to speed up the import process, and so I used the code...