Rabu, 15 Juli 2020

Re: [MSAccessProfessionals] Union Query vs. Append query

You can import them in the final table. Just add a date field of when you import them.

On Thu, Jul 16, 2020, 1:51 AM Sean Cooper via groups.io <smcjb=yahoo.com@groups.io> wrote:
Let me ask a related question.

Everyday I add about a 1000 records to my database. I currently import these into a new table and then through a union query combine them with my currrent records. At the end of the month I take all the daily tables and combine them into a monthly table and modify the union query to reflect that. So currently I have a union query that is combining 6 tables of monthly data and approximately 10 days of daily data to create a master data set. Would it be better if I just appended the new data everyday to a single table?

Sean


On Wednesday, July 15, 2020, 12:22:12 PM CDT, Paul Baldy <pbaldy@gmail.com> wrote:


I'm confused, as the two types of queries do different things.  You'd need to use the type that accomplished your goal.

Do you get 295k new records a day, or is that the total number of records in the table?  If the total, that's not really a large number, so you may not need to delete records.

Paul

On Wed, Jul 15, 2020 at 09:43 AM, Jim Wagner wrote:
Hello all,

I download every day records from hyperion and bring them into the database after exporting them to excel and then importing them into the database. because the record count is 295K i delete the records in the database from a certain date and then append the newly downloaded records thus keeping my record count low. 
But I was thinking today. what would be faster to do a union query or an append query?

Thanks for the thoughts

Jim Wagner

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#115693) | Reply To Group | Reply To Sender | Mute This Topic | New Topic

Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Tidak ada komentar:

Posting Komentar