Multi-Table Query

[Guest]

I receive a weekly csv report containing "package-level detail" for FedEx
shipments. The reports contain 36 columns and, on average, 50,000 rows. In
the past I would import each report into one table in Access. The problem I
would run into is that the table would become too large and the database
would start giving me errors. I would like to link the files to one database
and have a query that would search all the tables for specific critera and
return the results in one table. Whenever I try to set up the query, it
always includes all the columns from each queried table in the new table. I
thought I might try a cross-tab query, but I don't want to calculate the
fields. What can I do? Or do I need to do this in Sequel?

 

[Jeff Boyce]

First, do you need all 30+ fields for what you are doing?

Next, you don't give any info on the field sizes -- Access has a per-row
limit of roughly 2000 characters.

50,000 rows is not that big (but see previous comment). Without some idea
of what kind of error you received, it will be tough to guess what wasn't
working the way you wanted it to.

Creating a separate table for each import is probably not a great way to use
the strengths and capabilities of Access (or any other relational database).
If every import is identical (i.e., same data structure), except for the
date (each on a different day's info), the data belongs all in one table.
If there's too much data for Access to hold, certainly consider a more
robust data base engine.