Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How easy or hard to create Excel table from SQL DB

Posted on 2009-07-15
2
Medium Priority
?
218 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
kevin_u earned 1000 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this article I will describe the Backup & Restore 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.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

715 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