Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
retaining functionality while importing from EXCEL
- Thread starter Joels7
- Start date
MichaelRed
Programmer
If you actually import an Excel worksheet, ALL you get are the then current values. Even if you were to get macros, the range references would be irrelevant to the access tables, as the reference convention is rather different.
As for "auto-calculations" (I'm assuming that you are refereing to the "Sum(CellRef:CellRef)" type of 'quick macro', these would be even more foregin to Ms. Access, which would use aggregate queries for these.
I obviously do not know or understand the point of the exercise of transfering an Excel "application" to Ms. Access, so the following is intended only as a 'cosmetic' soloution, but you COLUL embed AN excel spreadsheet in an Ms. Access FORM and just activate it 'in place' (double click on it), do the 'work' and save the results.
To really convert a spreadsheet (or workbook) to a relational database requires more than even just importing the instance of the spreaadshhet and 'converting' the macros. If it is really useful to applt the power of relational database technology to the application, then sme analysis of how to reasonable utilize that power is also necessary.
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
As for "auto-calculations" (I'm assuming that you are refereing to the "Sum(CellRef:CellRef)" type of 'quick macro', these would be even more foregin to Ms. Access, which would use aggregate queries for these.
I obviously do not know or understand the point of the exercise of transfering an Excel "application" to Ms. Access, so the following is intended only as a 'cosmetic' soloution, but you COLUL embed AN excel spreadsheet in an Ms. Access FORM and just activate it 'in place' (double click on it), do the 'work' and save the results.
To really convert a spreadsheet (or workbook) to a relational database requires more than even just importing the instance of the spreaadshhet and 'converting' the macros. If it is really useful to applt the power of relational database technology to the application, then sme analysis of how to reasonable utilize that power is also necessary.
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
- Status
Similar threads
- Locked
- Question
- Locked
- Question