[Last Call] Learn how to a build a cloud-first strategyRegister Now


Email Excel Spreadsheet with ODBC Connection

Posted on 2012-09-10
Medium Priority
Last Modified: 2012-09-20

I have an Excel spreadsheet with 10 sheets containing tables
that are connected to my online SQL database. I need to email
the spreadsheet to someone so that it is still connected to the SQL database.

How do I do that?

Question by:Murray Brown
  • 2
LVL 35

Expert Comment

ID: 38388579
how would you get their e-mail addresses?

Author Comment

by:Murray Brown
ID: 38388723
I have the one email address that I am going to send it to already
LVL 22

Accepted Solution

Nico Bontenbal earned 2000 total points
ID: 38416822
That would only work if the receiver of the email has Access to the SQL Server database as well. If the receiver is outside your company that's probably not desirable. You need to talk to the administrator of SQL Server about this. Also within your company not everybody might have access to the SQL database.
If the receiver has access tot the database but get's an error message when refreshing the data it might be you are using an ODBC data source. The receiver of the mail has to create a datasource with the same name.

Author Closing Comment

by:Murray Brown
ID: 38417083
Thanks for the info

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

Ready to get certified? Check out some courses that help you prepare for third-party exams.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

830 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