what should I do?

D

Diane

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?
 
J

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

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]
 
D

Diane

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