I have a huge database that tracks my company's employee training. As of mid-July it was 154k records. The data comes to us as a .csv file. After importing and normalizing the data, I end up with 7 tables and a master table with lookups to the others.
I can easily append the data to each individual table. However after appending the new data it is not appearing in the queries that we use to isolate data. I am at a loss as to why the data isn't linked. I am sure I have forgotten something as it has been close to 20 years since I last worked with Access.
Thanks for any ideas you can give me...
I can easily append the data to each individual table. However after appending the new data it is not appearing in the queries that we use to isolate data. I am at a loss as to why the data isn't linked. I am sure I have forgotten something as it has been close to 20 years since I last worked with Access.
Thanks for any ideas you can give me...