Phoenix - Your AI AssistantA sample excel spreadsheet connected via SQL to the default 'Nwind' database.
- Posted:
- Proposals: 9
- Remote
- #332737
- Awarded
Lahore 
Description
Experience Level: Intermediate
Estimated project duration: Not known
Hi,
I would like someone to generate an Excel (Excel 2007 compliant) spreadsheet for me that connects to the default - 'Nwind.mdb' - Microsoft database. Once connected I would like the spreadsheet to contain 3 types of connection. These are:
1) A cell formula executing some sql to bring back a value from the database.
2) A pivot table connected to one of the tables and summarising some totals.
3) Some VBA code showing a loop bring back multiple values from the database.
Many thanks in advance,
Peter
I would like someone to generate an Excel (Excel 2007 compliant) spreadsheet for me that connects to the default - 'Nwind.mdb' - Microsoft database. Once connected I would like the spreadsheet to contain 3 types of connection. These are:
1) A cell formula executing some sql to bring back a value from the database.
2) A pivot table connected to one of the tables and summarising some totals.
3) Some VBA code showing a loop bring back multiple values from the database.
Many thanks in advance,
Peter
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.