G
gregork
I have created an excel workbook that basically consists of one sheet for
recipe formulation and one sheet that is basically a database of raw
materials and their specifications. When I formulate a recipe on sheet 1, I
use numerous lookups to sheet 2 to formulate the right blend. I now have
decided that my database would be better maintained if it was on access so I
really need some definitive answers on the following questions:
1. If I have my data on access can my excel spreadsheet still use lookups
based on the data cells in access?
2. If yes to above - will I have to re-write all my excel formulas or is
there a way around this?
3. What is the correct procedure for conversion. i.e. do I start with my
excel sheet and go >data>convert to ms access... or should I start in access
and go >file>get external data.... or ?
4. When I formulate a recipe in excel I also want certain information
(recipe No. , date, weight,etc) sent to an access database when I print or
hit an enter button. How do I do this and can it be recorded in a secondary
database in the same file as my raw material database?
Sorry to ask so many questions all at once but access is completely foreign
to me and I really don't want to waste time starting off on the wrong track.
Many thanks in advance to anyone offering advice.
gregork
recipe formulation and one sheet that is basically a database of raw
materials and their specifications. When I formulate a recipe on sheet 1, I
use numerous lookups to sheet 2 to formulate the right blend. I now have
decided that my database would be better maintained if it was on access so I
really need some definitive answers on the following questions:
1. If I have my data on access can my excel spreadsheet still use lookups
based on the data cells in access?
2. If yes to above - will I have to re-write all my excel formulas or is
there a way around this?
3. What is the correct procedure for conversion. i.e. do I start with my
excel sheet and go >data>convert to ms access... or should I start in access
and go >file>get external data.... or ?
4. When I formulate a recipe in excel I also want certain information
(recipe No. , date, weight,etc) sent to an access database when I print or
hit an enter button. How do I do this and can it be recorded in a secondary
database in the same file as my raw material database?
Sorry to ask so many questions all at once but access is completely foreign
to me and I really don't want to waste time starting off on the wrong track.
Many thanks in advance to anyone offering advice.
gregork