Käynnissä

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ää: export data to excel from sql server 2008 using query, sql import and export wizard, tsql export to excel, sql server export results to excel, how to export data from sql server to excel using query, how to export data from sql server 2012 to excel using query, import data from excel to sql server using query, sql server export to excel from stored procedure, 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

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

Projektin tunnus: #15815479

Myönnetty käyttäjälle:

rayyankabir

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)
0.0

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

mail2vimalarora

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)
6.0
$25 USD 1 päivässä
(0 arvostelua)
0.0