I have a query and report in Access that I would LOVE to be able to export into specific cells in Excel that would allow working functions.
Below is a version of what I need the Excel sheet to be/do (the text in red is the data that I want pulled from my Access database. The reason I need it pulled into Excel is that many of our clients use these forms digitally to enter the Employee and Employer contribution amounts and use the Excel formula to calculate the totals automatically.
Any ideas/advice?
TIA!
[TABLE="width: 601"]
<TBODY>[TR]
[TD="colspan: 6"]CA Technologies, Inc.</SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 6"]Client ID # 2815562000</SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 6"]For the Contribution Period</SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 6"]Beginning: ________________ 2013</SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 6"]Ending: __________________ 2013</SPAN>[/TD]
[/TR]
[TR]
[TD]Payor SSN</SPAN>[/TD]
[TD]Employee Name</SPAN>[/TD]
[TD]Contract Number</SPAN>[/TD]
[TD]Employee Amount</SPAN>[/TD]
[TD]Employer Match Amount</SPAN>[/TD]
[TD]Total Deposits</SPAN>[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[TD]XXX-XX-6404</SPAN>[/TD]
[TD]Gina H</SPAN>[/TD]
[TD]536668503</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]XXX-XX-2847</SPAN>[/TD]
[TD]Austin L</SPAN>[/TD]
[TD]546050705</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]XXX-XX-1946</SPAN>[/TD]
[TD]Chad W. M</SPAN>[/TD]
[TD]533962702</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]XXX-XX-2684</SPAN>[/TD]
[TD]Tyler M</SPAN>[/TD]
[TD]546062009</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]XXX-XX-9500</SPAN>[/TD]
[TD]Dana M</SPAN>[/TD]
[TD]541433606</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]XXX-XX-7336</SPAN>[/TD]
[TD]Mark V</SPAN>[/TD]
[TD]541433806</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]XXX-XX-3470</SPAN>[/TD]
[TD]Bernard W</SPAN>[/TD]
[TD]540487507</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Totals:</SPAN>[/TD]
[TD] $ - </SPAN>[/TD]
[TD] $ - </SPAN>[/TD]
[TD] $ - </SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 6"]Please make checks payable to Insurance Company, and return with form to:</SPAN></SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Our Office
45 3rd Ave S, Suite 15
City, State Zip</SPAN>[/TD]
[TD="colspan: 4"][/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL span=3></COLGROUP>[/TABLE]
Below is a version of what I need the Excel sheet to be/do (the text in red is the data that I want pulled from my Access database. The reason I need it pulled into Excel is that many of our clients use these forms digitally to enter the Employee and Employer contribution amounts and use the Excel formula to calculate the totals automatically.
Any ideas/advice?
TIA!
[TABLE="width: 601"]
<TBODY>[TR]
[TD="colspan: 6"]CA Technologies, Inc.</SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 6"]Client ID # 2815562000</SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 6"]For the Contribution Period</SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 6"]Beginning: ________________ 2013</SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 6"]Ending: __________________ 2013</SPAN>[/TD]
[/TR]
[TR]
[TD]Payor SSN</SPAN>[/TD]
[TD]Employee Name</SPAN>[/TD]
[TD]Contract Number</SPAN>[/TD]
[TD]Employee Amount</SPAN>[/TD]
[TD]Employer Match Amount</SPAN>[/TD]
[TD]Total Deposits</SPAN>[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[TD]XXX-XX-6404</SPAN>[/TD]
[TD]Gina H</SPAN>[/TD]
[TD]536668503</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]XXX-XX-2847</SPAN>[/TD]
[TD]Austin L</SPAN>[/TD]
[TD]546050705</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]XXX-XX-1946</SPAN>[/TD]
[TD]Chad W. M</SPAN>[/TD]
[TD]533962702</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]XXX-XX-2684</SPAN>[/TD]
[TD]Tyler M</SPAN>[/TD]
[TD]546062009</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]XXX-XX-9500</SPAN>[/TD]
[TD]Dana M</SPAN>[/TD]
[TD]541433606</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]XXX-XX-7336</SPAN>[/TD]
[TD]Mark V</SPAN>[/TD]
[TD]541433806</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]XXX-XX-3470</SPAN>[/TD]
[TD]Bernard W</SPAN>[/TD]
[TD]540487507</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Totals:</SPAN>[/TD]
[TD] $ - </SPAN>[/TD]
[TD] $ - </SPAN>[/TD]
[TD] $ - </SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 6"]Please make checks payable to Insurance Company, and return with form to:</SPAN></SPAN>[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Our Office
45 3rd Ave S, Suite 15
City, State Zip</SPAN>[/TD]
[TD="colspan: 4"][/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL span=3></COLGROUP>[/TABLE]