Manipulation of Data extract from Access Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you set up an Excel spreadsheet which can act as a view of a Access table
and allow direct update of that table?

If possible how do I set it up?

Regards

Charles Moore
 
You can do it but it requres a reasonably good understanding of VBA macros
and ADO Recordsets.

Reading the data into a spreadsheet is relatively easy. You can use Data ->
Import External Data -> New Database Query... It is writing back that is
the tricky part.
 
Yes.

You must use Visual Basic for Application(VBA), which is a programming
environment built within Microsoft Excel.

You can create one or more Data Source name'c (DSN) to connect and perform
operation on databases in Microsoft Access. However, the data in excel
requires lot of cleaning before transforming the information to Excel. This
is mostly recommended when you use Forms for User Interface Designing in
application developemnt using Microsoft Excel.

Challa Prabhu
 
Back
Top