• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

Email Excel Spreadsheet with ODBC Connection

Hi

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?

Thanks
0
Murray Brown
Asked:
Murray Brown
  • 2
1 Solution
 
YZlatCommented:
how would you get their e-mail addresses?
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
I have the one email address that I am going to send it to already
0
 
Nico BontenbalCommented:
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.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks for the info
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now