Access to a formatted Excel spreadsheet process... Is it easy?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a series of Excel spreadsheets that have become unwieldly which is why
I'm converting them to a DB. Though the spreadsheets have become "expected"
report formats, I'm wondering "how painful" it'll be from a newbie-mediate
level to make this happen, that is, keep the formats of the existing Excel
reports but generated from Access. I'd like to keep it as open ended as
possible to allow future enhancements. ie. Data Access Pages, user levels of
security, to name a few "like to have" features.
 
It is certainly possible since you can automate Excel from Access and
anything in Excel exposed to VBA (this means almost all if not all things).

You do need to know quite a bit of VBA programming and the Excel Object
Model, especially that the number of Objects in Excel is quite big.
 
Back
Top