Linking Excel spreadsheets to reports

  • Thread starter Thread starter Charlene Potter
  • Start date Start date
C

Charlene Potter

Is there a way to link an excel spreadsheet to a report
that will come up if you click on a command button or
something like that?
 
You can link the Excel spreadsheet into the db by going to
File - Get External Data - Link Tables and choosing the
appropriate file (be sure to change the files of type to
Excel -.xls)
Then you can make a report based on the linked Excel file.
You can add a command button to a form that will open the
Report.

Good Luck!
 
You could insert and OLE object which could be and excel
spreadsheet or chart. I would suggest linking instead of
mbedding it to reflect latest changes in the Excel file.

Jim
 
Back
Top