Moving Info? (Office XP)

Topic

New Reply

Ok, so here’s my new dilemma;
I can pull info from an external data source that will make an excel document for me. I want to import that data into my existing access table, and importing the excel file to access is no problem. Problem here is that the external data source doesn’t always have the same people that are in my existing access table (usually LESS), making less records. I do have exact social security numbers on both documents (which is what I want to use to link the tables), however when I try a Make-Table query, it DELETES the rows that do not appear (are not found from the external data source) in the imported table. Without having tried an external table with MORE records than on my table, I can only assume that Access will follow suit and ADD the names I do not have the info for (which I do not want it to do either). I do not mind importing entire columns of data from the external data source as long as that data matches across the board (SSNs match, therefore the info in the record is on the right person). I’m unable to post an example right now, but will do so ASAP.

Reply | Quote

Replies

A make-table query will (as the name indicates) create a new table. If there is already a table with the name of the target, you’ll be prompted if you want to overwrite it. If you confirm, the original table will be deleted before the new one is created.

Reply | Quote

I understand it will make a new table…I’m ok with that, what I don’t want to change is my original list of records.

Reply | Quote

You can create an append query that will only append records that don’t have a matching SSN in the original table. If you want to update existing records, you can create an update query that will only modify records that have a matching SSN in the original table.

Reply | Quote

In an update query, how do you assign a destination?

Reply | Quote

When you change a query to an update query (Query | Update Query), a new row appears in the query design grid: Update to. Only those columns for which you enter something in the Update to row, will be updated. If your query is based on two tables (linked by SSN), you can specify a field from the other table as update value:
[NameOfTable].[NameOfField]

Reply | Quote

When you change a query to an update query (Query | Update Query), a new row appears in the query design grid: Update to. Only those columns for which you enter something in the Update to row, will be updated. If your query is based on two tables (linked by SSN), you can specify a field from the other table as update value:
[NameOfTable].[NameOfField]

Reply | Quote

In an update query, how do you assign a destination?

Reply | Quote

You can create an append query that will only append records that don’t have a matching SSN in the original table. If you want to update existing records, you can create an update query that will only modify records that have a matching SSN in the original table.

Reply | Quote

I understand it will make a new table…I’m ok with that, what I don’t want to change is my original list of records.

Reply | Quote

A make-table query will (as the name indicates) create a new table. If there is already a table with the name of the target, you’ll be prompted if you want to overwrite it. If you confirm, the original table will be deleted before the new one is created.

Reply | Quote