Solved

How easy or hard to create Excel table from SQL DB

Posted on 2009-07-15
2
185 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now