Append Query

  • Thread starter Thread starter Jacinda
  • Start date Start date
J

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??
 
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??
Click to expand...

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?
 
Back
Top