Simple & Urgent SQL to Excel connection

I have two files in my SQL database that I am wanting to link to excel. I have attached the format it is in SQL (nxtweek calculations)(and how I want it to show in Excel (schedule template). A couple of things:

- I want the daily calculations "hidden unless expanded"

- I want to Forecasted Sales & Total Scheduled COL not hidden and all other KPI's hidden unless Scheduled COL is expanded.

I have a few other requirements which I can discuss on the messaging service

Taidot: Tietokantaohjelmointi, Microsoft Access, Microsoft SQL Server, MySQL, SQL

Näytä lisää: create a sql database and create a simple but good looking website where i can access and query the database, sql excel database, merge sql database files, simple gui sql database, simple user interface excel database, simple sql readonly database iphone, convert bak files sql excel, simple store inventory excel files, needed files excel database, simple excel database online php, simple sql php database add delete modify, simple excel database program, simple excel database, pdf files sql server database, upload excel database sql server using

Tietoa työnantajasta:
( 9 arvostelua ) brandon, United States

Projektin tunnus: #15815479

Myönnetty käyttäjälle:


Fetch the data using ADODB in Excel from SQL Server. I would prefer to create a view on the server side with all the calculation. If that's possible, well and good otherwise I can do it on Excel too. Relevant Skills a Lisää

$25 USD 1 päivässä
(0 Arvostelua)

3 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hi.. I have gone through your project details and would like to take an opportunity to work on it. Being experienced in handling sql, excel, connections between them, based on which i can help you with solution quickly Lisää

$50 USD 2 päivässä
(111 arvostelua)
$25 USD 1 päivässä
(0 arvostelua)