Importing Specific Fields to Table

[Guest]

Your help is GREATLY appreciated.

I have a table of project information which has a unique project # as the
primary key, and there is a whole slew of information that I record about a
project.......here is the question.

Every month we receive an updated report of key financial figures from the
accounting system, and I would like to be able to import those updated
financial figures into my Access database based on the project #.

How do you create (I am assuming) an update query that will go through the
Excel table of updated financials, identify a matching project number, and
then update a few of the financial figures (for example: Revenue, Cost, GPD,
GPP)

Thanks

 

[pietlinden]

Your help is GREATLY appreciated.

I have a table of project information which has a unique project # as the
primary key, and there is a whole slew of information that I record about a
project.......here is the question.

Every month we receive an updated report of key financial figures from the
accounting system, and I would like to be able to import those updated
financial figures into my Access database based on the project #.

How do you create (I am assuming) an update query that will go through the
Excel table of updated financials, identify a matching project number, and
then update a few of the financial figures (for example: Revenue, Cost, GPD,
GPP)

Thanks

One way is to attach the Excel table and then query it as if it were a
local table.

Put the two tables into your QBE grid, connect the primary keys, and
then you can run an update query of the Access table. But I would
make a backup of the Access table until you're sure it's right, since
you can't undo it.