Append Query

[Jacinda]

My Brain is fried and I lost my book...

I have data from an outside source that is not really user friendly, but now
I have a way to update several tables from that source.

The outside data is my most recent information, and I want to append the
data to my tables... for example:

Orders data is linked to the outside source, which is updated regularly
In Access I have tblOrders, which includes other fields but I need to append
the new data from the first table.

When I tried this at first I was getting over 85K in matches.... what am I
missing??

 

[John W. Vinson]

My Brain is fried and I lost my book...

I have data from an outside source that is not really user friendly, but now
I have a way to update several tables from that source.

The outside data is my most recent information, and I want to append the
data to my tables... for example:

Orders data is linked to the outside source, which is updated regularly
In Access I have tblOrders, which includes other fields but I need to append
the new data from the first table.

When I tried this at first I was getting over 85K in matches.... what am I
missing??

Since you don't say what you're doing, or anything about the unfriendly format
of this external source, I can't imagine how anyone could answer.

More info please! How are you doing this update?