UPDATE DATA FROM ONE FILE WITH DATA FROM ANOTHER

[Barry]

I have a LARGE parts inventory database from one of our vendors. We get
periodic price and new parts updates from this vendor. Is it possible to
update the database automatically with the new update file that I get?

 

[David Lloyd]

Barry:

While one could write a macro to do this update, in my opinion, it would be
easier to link the two Excel worksheets into Access and write a query to do
the update for you.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have a LARGE parts inventory database from one of our vendors. We get
periodic price and new parts updates from this vendor. Is it possible to
update the database automatically with the new update file that I get?

 

[Barry]

David:
Thank you for your reply. One of the problems I am experiencing is,
although I have some experience with MS-Office, I find that the manuals that
came with the program is too vague in explanation. Were do I find an
understandable narration on how to accomplish these tasks?

 

[David Lloyd]

Barry:

From Access, you can link the Excel workbooks by going to the File menu, Get
External Data, Link Tables... In the Files of Type combo box at the bottom
of the dialog select Microsoft Excel, and then browse to one of your two
workbooks (Master and Update). You will need to do this procedure once for
each workbook. Once the wizard starts just select the worksheet and follow
the prompts. Once the two worksheets are linked in, Access treats them
essentially the same as any other Access tables. Any updates to the linked
tables are reflected in the underlying worksheet in the workbook.

With regard to creating an Append query to move the updated information into
the Master table, the following KB article gives the basics:

http://support.microsoft.com/default.aspx?scid=kb;en-us;306093

Additional Access resources include the following:

http://mvps.org/access/
http://msdn.microsoft.com/office/understanding/access/

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


David:
Thank you for your reply. One of the problems I am experiencing is,
although I have some experience with MS-Office, I find that the manuals that
came with the program is too vague in explanation. Were do I find an
understandable narration on how to accomplish these tasks?