How do I create a database and table with a user and password in Excel via ODBC?
I am writing a generic database engine and need to support Excel via ODBC. I need to test the user and password configuration used by our server for Excel.
However I am not sure whether this exists as a concept in Excel. Password protecting the sheet via the menu has no effect as the ODBC commands simply access and update it without hindrance.
Create table does not seem to provide the required functionality, Alter table is not supported.
Am I missing something or is this just not possible?
excel database odbc
asked Nov 23 '18 at 15:48
Stefan
2,54311829
add a comment |
I am writing a generic database engine and need to support Excel via ODBC. I need to test the user and password configuration used by our server for Excel.
However I am not sure whether this exists as a concept in Excel. Password protecting the sheet via the menu has no effect as the ODBC commands simply access and update it without hindrance.
Create table does not seem to provide the required functionality, Alter table is not supported.
Am I missing something or is this just not possible?
excel database odbc
asked Nov 23 '18 at 15:48
Stefan
2,54311829
add a comment |
I am writing a generic database engine and need to support Excel via ODBC. I need to test the user and password configuration used by our server for Excel.
However I am not sure whether this exists as a concept in Excel. Password protecting the sheet via the menu has no effect as the ODBC commands simply access and update it without hindrance.
Create table does not seem to provide the required functionality, Alter table is not supported.
Am I missing something or is this just not possible?
excel database odbc
asked Nov 23 '18 at 15:48
Stefan
2,54311829
I am writing a generic database engine and need to support Excel via ODBC. I need to test the user and password configuration used by our server for Excel.
However I am not sure whether this exists as a concept in Excel. Password protecting the sheet via the menu has no effect as the ODBC commands simply access and update it without hindrance.
Create table does not seem to provide the required functionality, Alter table is not supported.
Am I missing something or is this just not possible?
excel database odbc
excel database odbc
asked Nov 23 '18 at 15:48
Stefan
2,54311829
asked Nov 23 '18 at 15:48
Stefan
2,54311829
asked Nov 23 '18 at 15:48
Stefan
2,54311829
asked Nov 23 '18 at 15:48
Stefan
2,54311829
asked Nov 23 '18 at 15:48
Stefan
2,54311829
2,54311829
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53449586%2fhow-do-i-create-a-database-and-table-with-a-user-and-password-in-excel-via-odbc%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53449586%2fhow-do-i-create-a-database-and-table-with-a-user-and-password-in-excel-via-odbc%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
