You can link access to Excel. But why? before going any further, explain
the reason why you would want to do this. Let us evaluate what your needs
are.
Access Forms are much better for data entry, for a number of reason, than
Excel. What would you use acces for then if your data is being entered and
stored in Excel? Explain some more so we can guide you better.
The actual reason for using excel to enter the fields in access is that over
100 of our users are familiar with excel, but do not know anything about
databases. They actually call excel a database about 1/2 of the time.
We work in a contract research facility that does lots of different projects
in several scientific disciplines of varying complexity. I started using
databases to store my research data in back in the 80's with db3. We did not
even have an IT department until about 2 years ago. I have been trying to
drag our company into today's world for the last 15 yrs, and am convinced
that the only way I'm going to get this done is if I create excel worksheets
that they fill out and the data goes into a database that I can then show
them what benefits and additional data evaluation techniques are available.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
