Make Table ?

[Abdul]

Hello All,

I have a query to get data from our tables using Left join and Union
all.

Now every time I get the data by using a Make Table query. Since the no
of records are huge it takes a lot of time (even hours) to make the
table. (the data is taken from web).

Now is there a way to get only the new records from the table instead
of getting them all again.

Like if I have already 200000 records in my table then append only the
new records to my table from the web?

Thanks

 

[Jeff Boyce]

Abdul

You can use an Append query in Access to add records. If you want to add
only the "new" records, Access will need a way to tell which records are
"new" and which are "old". How would you be able to tell this, and could
you use this to tell Access how to tell?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Abdul]

New records means all the records which are not in the current table.

Also when these records are appended this is done in a single bunch, I
assume. So if the connection is lost nothing is added.

Is there a way to get these records uppended one by one so even if the
connection is lost only the remaing to be updated later?

Thanks

 

[Jeff Boyce]

If you were to tell an assistance to add records, how would that person know
which records were not in the current table? Is there some unique
identifier?

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/