View Single Post
  #1   Report Post  
ChrisBat
 
Posts: n/a
Default Excel -> Access -> Excel

Hi,

I'm working on an Access 2000 database where I will have a spreadsheet on a
network drive. i need people from other groups to update the spreadsheet,
but i need that info carried into the database and then back onto the
spreadsheet. i have the access - excel part figured out (I'm using the
database query using Excel), but now I need to figure out how to go from
excel - access. Anybody have any idea how this can be done? (Is it as
simple as a link directly into the database? I tried that, but my update
query in the database won't update anything....)
Thanks,
Chris