Solved

How easy or hard to create Excel table from SQL DB

Posted on 2009-07-15
2
201 Views
Last Modified: 2012-05-07
How hard or easy is it to ceate an excel file from within SQL Server?  

I am an Access developer working with others who own a SQL Server 2005 database.  They need to send me information from that database from time to time.  I am told they can send it to me in CSV format, it would be better on my end if I got in in an Excel format.

Is it reasonable to ask them to send it to me in that format?  Any harder for them to do that than to send it to me in CSV?

Thank you
0
Comment
Question by:WoodrowA
2 Comments
 
LVL 12

Accepted Solution

by:
kevin_u earned 250 total points
ID: 24863419
SQL server will not directly export to .xls or .xlsx

So the folks with the SQL server would have to export to .csv then open it in excel (or create an automated process to do so), and save it as excel, then send it to you.

.csv files are usually directly opened by excel.  If they send you a .csv and you double click on it it'll open.   Also .csv's can be directly opened by access.
0
 

Author Closing Comment

by:WoodrowA
ID: 31603916
Thank you.  That was very helpful.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question