Saturday 11 September 2010

Transfer between MS Access and MS Excel

SSS have carried out work on behalf of one of clients to export data from Access to Excel and also manipulate the appearance within the spreadsheet from the Access code. Functions achieved were:
  • Export of 7 queries to separate worksheets within the same spreadsheet
  • Export of data to another spreadsheet, setting the cell colours dependant upon the urgency level of the data.
We can see applications of this arrangement within INTACT.

No comments:

Post a Comment