Hello, I am wondering if it's possible to create one big table and have the options to filter it once loaded to create different tables from it that I can use when pulling reports. I think I am wasting time by uploading 3 different excel spreadsheets when I can combine them and filter out the results I need for three different clients. Is this possible?:banghead:
Saving a new table from a filtered table (1 Viewer)
- Thread starter Jcarpe78
- Start date
MarkK
bit cruncher
- Local time
- Today, 15:56
- Joined
- Mar 17, 2004
- Messages
- 8,179
Welcome to the forum!!!
IMO,
Mark
There is no need to create temp tables from a table to create reports. Just use a query.
IMO,
Mark
Excuse my ignorance in access. I am new to this program. I am trying to import client information that is in an excel spreadsheet into access. From there I use the query to point to the correct data and than I generate reports such as data and so forth. Before, I was importing the random sample than the sample from the coders, and later all files combined. In my head, I thought I could upload one huge combined file and add a letter to the back of the identifying numbers tab to differentiate or filter between samples.
- Local time
- Today, 23:56
- Joined
- Jul 9, 2003
- Messages
- 16,271
It's normal to do the opposite, import one table, but divided up into several different tables.
See here for more info on this common problem affecting people who bring Excel data into MS Access:-
http://www.niftyaccess.com/excel-in-access/
Sent from my SM-G925F using Tapatalk
- Local time
- Today, 18:56
- Joined
- Feb 19, 2002
- Messages
- 43,216
The others seem to have a different take on this than I do but I don't see any problem with importing multiple spreadsheets into the same table. Since you need to keep the source distinguished, the best solution is to link to the spreadsheet and then use an append query. The append query also allows you to accommodate differences in field name and field order that might occur with different spreadsheets. In the append query, you can have an additional field that indicates the source of the data. Do NOT concatenate this discriminator with some other field. Keep it separate for ease of use.
