Manipulation of Data extract from Access Database
 

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

Manipulation of Data extract from Access Database
 

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.
--
HTH...

Jim Thomlinson


"Chase" wrote:

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

Manipulation of Data extract from Access Database
 

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

"Chase" wrote:

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