what should I do?

[Guest]

I've been tasked to create a db for my division which includes our inventory
assets (pc's, monitors, other peripherals). I have data from an existing db
on the personnel and data from an existing spreadsheet on the inventory
assets. How do I put these two together?

 

[John Vinson]

I've been tasked to create a db for my division which includes our inventory
assets (pc's, monitors, other peripherals). I have data from an existing db
on the personnel and data from an existing spreadsheet on the inventory
assets. How do I put these two together?

By building a suitably normalized database (perhaps starting with
Microsoft's Inventory template), and using File... Get External
Data... Link to link to the spreadsheets; then running Append queries
to populate your Access tables. The details will depend very much on
how the data is structured in your spreadsheets, and (if it's typical
of Excel 'databases') may be a fairly big pain in the neck.

John W. Vinson[MVP]

 

[Guest]

Thanks John, but where do I find this Microsoft inventory template? And the
existing db is in Access 97.

 

[John Vinson]

Thanks John, but where do I find this Microsoft inventory template?
http://office.microsoft.com/en-us/templates/TC010184581033.aspx?CategoryID=CT011366681033

And the existing db is in Access 97.

Later versions of Access can easily upgrade an A97 database. What
version of Access do you have installed?


John W. Vinson[MVP]