Export Access database to Excell or another platform

[Guest]

I have an access database which a potential customer likes and wanted to
purchase. They were stopped by their IT department who will not give them MS
Access software. The customer then asked if it was possible to export the
application to a different platform eg Microsoft Excel which they have
already installed on their computers. My query is really 3 as follows ! :

1) Is there an easy way to export the database (including queries,
forms etc) to excel? If so - can anyone please give me some guidance?

2)Is there a way for the customer to use the database without the access
program.

3) Is there a way to export access to an application which can be compiled
as a free standing application - even if I have to work in visual basic?

I would welcome any suggestions which will point me in the right direction.
At the moment I am trawling the web for ideas without much success.

Thanks in a advance.

Peter

 

[Douglas J. Steele]

While you can export the data from Access to Excel, you cannot export forms,
reports or macros. Forms in Access are very diffferent than the User Forms
in Excel, Excel has no Report objects, and there's nothing equivalent to
Access macros in any other Office product. You should be able to
copy-and-paste any VBA code, but there are differences in the Object Models
between the two products, so you'll likely have to do some recoding in
Excel.

There is no way to use an Access application without Access (nor to compile
it into a stand-along application). However, there is a royalty-free
run-time available for Access. This allows you to package your application
together with the run-time. Users who do not have Access already installed
can install the run-time and use your application. (They will not be able to
make any design changes to the application). This packaging does not change
your application in any way, shape or form, so it's important to ensure that
your application is robust enough to work with the run-time (good error
handling is critical). Tony Toews has an introduction to this topic at
http://www.granite.ab.ca/access/developereditionfaq.htm

 

[Guest]

Many thanks.

While you can export the data from Access to Excel, you cannot export forms,
reports or macros. Forms in Access are very diffferent than the User Forms
in Excel, Excel has no Report objects, and there's nothing equivalent to
Access macros in any other Office product. You should be able to
copy-and-paste any VBA code, but there are differences in the Object Models
between the two products, so you'll likely have to do some recoding in
Excel.

There is no way to use an Access application without Access (nor to compile
it into a stand-along application). However, there is a royalty-free
run-time available for Access. This allows you to package your application
together with the run-time. Users who do not have Access already installed
can install the run-time and use your application. (They will not be able to
make any design changes to the application). This packaging does not change
your application in any way, shape or form, so it's important to ensure that
your application is robust enough to work with the run-time (good error
handling is critical). Tony Toews has an introduction to this topic at
http://www.granite.ab.ca/access/developereditionfaq.htm