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!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert Excel Workbook into Access Report and Dynamically Update

Status
Not open for further replies.
Mike555

Mike555

Technical User
Feb 21, 2003
1,200
US
I have an Excel workbook filled with literally hundreds of various formulas and calcuations. For years my company has copied data from a Microsoft Access query into this Excel file in order to manipulate the Access data. I'd like to automate this process by moving the logic from the spreadsheet into an Access Report, thus eliminating the need for Excel. Is there someway that I can copy/paste the worksheet format and formulas into Access, instead of having to re-write all the Excel formulas to work with Access's report controls, and have specific cells filled with specific data from Access? Thanks!

--
Regards,
Mike
 
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Access 365 Report use nickname if exist instead of 1st name
Replies
4
Views
2K
renigar
renigar
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
511
dhookom
dhookom
GPnew
  • Locked
  • Question
Access 2016 report export to excel column order changes
Replies
2
Views
215
GPnew
GPnew
EwaFAMA
  • Locked
  • Question
ACCESS - Adding image from URL to the report 1
Replies
11
Views
3K
EwaFAMA
EwaFAMA
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
487
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top