coolhandphil
New member
- Local time
- Today, 23:07
- Joined
- Sep 5, 2014
- Messages
- 6
Hi,
I'm using Microsoft Access 2010. I want to create a database that people without Microsoft Access can use. I'm not sure if this is possible...
If I create a database is it possible to use VBA in Excel to update a table in Access and then run/export a query? I know you can use Excel to communicate with MS Access but can you do it when you don't have MS Access installed on your computer?
I have daily sales data that I want someone without MS Access to be able to load into the database and then export a query from.
Any ideas?
Thanks,
Phil
I'm using Microsoft Access 2010. I want to create a database that people without Microsoft Access can use. I'm not sure if this is possible...
If I create a database is it possible to use VBA in Excel to update a table in Access and then run/export a query? I know you can use Excel to communicate with MS Access but can you do it when you don't have MS Access installed on your computer?
I have daily sales data that I want someone without MS Access to be able to load into the database and then export a query from.
Any ideas?
Thanks,
Phil