Export Data and populate existing Excel Spreadsheet Fields

  • Thread starter Thread starter Wesley H
  • Start date Start date
W

Wesley H

Good Afternoon. I hope someone can help me with this. I working on a
project for a client in which they have an existing Excel Spreadsheet that
has about 8 fields with about 700 rows of data. I have another user that is
storing data into a Access database, and I want this data to be able to
export and populate the existing fields on the Excel spreadsheet. How do I
do this? There has got to be a way to do this without writing VB code. I
am a Network admin, not a programmer so I need help with this one!!

Thanks,
Wes H
 
Wesley,

If you want to manually select records from the Access database, then the
cut & paste suggestion will probably work. If you want to get records based
on criteria that you supply (quantity > 0, etc.) then a query can do that,
and the data will be up-to-date. In Excel, check out Data - Import External
Data - New database query.
 
Thanks! But what I want the office person to be able to do is query I
guess, but then update the Excel spreadsheet and then have the data put back
into the database. Is there a way to do that?
 
Back
Top