passinthru
Board Regular
- Joined
- Jun 16, 2003
- Messages
- 185
I have a few dozen tables (which currently exist as separate tab delimited ASCII files) which I need to import into Access, then run a query on them. Each table contains data (hours worked, that sort of thing) for a separate project. (The files were exported from an Oracle database. Don't ask why I can't get Oracle to do this - it's all too painful. I work with people who think everything in the world should be done on Excel. A database is just a place to store information until you need to manipulate it in Excel.)
I've created a query on one of them as a trial run, and it works fine. (It's a very simple query - just totals hours worked by employee grade level.)
How do I create a query that I can run on any of the tables? Pick a table - run the query. I don't want to create the same query for each table.
Bonus points if you can help me automate the import of the flat ASCII tables!
OR should I import them as one (I can concatenate the flat files into one) and make the query separate the data by project?
I have ZERO knowledge of VBA in Access. Running 2002 under WinXP Pro.
I've created a query on one of them as a trial run, and it works fine. (It's a very simple query - just totals hours worked by employee grade level.)
How do I create a query that I can run on any of the tables? Pick a table - run the query. I don't want to create the same query for each table.
Bonus points if you can help me automate the import of the flat ASCII tables!
OR should I import them as one (I can concatenate the flat files into one) and make the query separate the data by project?
I have ZERO knowledge of VBA in Access. Running 2002 under WinXP Pro.