View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ray_johnson
 
Posts: n/a
Default Open an Access table in Excel

I want to be able to open an Access table (from an .mdb file) in Excel 2003
and then use the data I've entered in Excel to update the Access table. I
think this has something to do with ODBC, but I am just stumped!

I can do it (sort of) in Open Office, but it's kind of clunky for this
application. Can it be done in Excel?

(Obviously, I don't have Access...but you knew that already, right? :) )

Thanks,
Ray