Oracle SQL Developer - load Excel file into sql server
I am trying to import Excel data into a table in SQL Developer.
I have created table in SQL Developer. Then I use Data Import Wizard to import the Excel file into the table.
The problem comes when dealing with date/time information. See picture Data Import Wizard 2, I just can't seem to get the correct date/time format correct.
I think the format string should be DD/MM/YYYY HH:MM. But this doesn't work. My other attempts failed too.
Would appreciate any advice on this. Thank you.
P.S. I am learning from the following youtube video.
https://www.youtube.com/watch?v=gR47cdxZibA
Raw data:
Table properties:
Data Import Wizard:
Data Import Wizard 2:
sqldeveloper
edited yesterday
Twisty Impersonator
17.8k146495
asked yesterday
Ombre
1
New contributor
Ombre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I am trying to import Excel data into a table in SQL Developer.
I have created table in SQL Developer. Then I use Data Import Wizard to import the Excel file into the table.
The problem comes when dealing with date/time information. See picture Data Import Wizard 2, I just can't seem to get the correct date/time format correct.
I think the format string should be DD/MM/YYYY HH:MM. But this doesn't work. My other attempts failed too.
Would appreciate any advice on this. Thank you.
P.S. I am learning from the following youtube video.
https://www.youtube.com/watch?v=gR47cdxZibA
Raw data:
Table properties:
Data Import Wizard:
Data Import Wizard 2:
sqldeveloper
edited yesterday
Twisty Impersonator
17.8k146495
asked yesterday
Ombre
1
New contributor
Ombre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
And the format field is not an input field where you can put dd/mm/yyyy HH12:mi ?
– Stian Yttervik
yesterday
So what should I do? Am I supposed to modify my data in Excel to fit the default formats?
– Ombre
yesterday
I would assume you use this to tell sql developer in what format the date you are importing is formatted in.
– Stian Yttervik
yesterday
add a comment |
I am trying to import Excel data into a table in SQL Developer.
I have created table in SQL Developer. Then I use Data Import Wizard to import the Excel file into the table.
The problem comes when dealing with date/time information. See picture Data Import Wizard 2, I just can't seem to get the correct date/time format correct.
I think the format string should be DD/MM/YYYY HH:MM. But this doesn't work. My other attempts failed too.
Would appreciate any advice on this. Thank you.
P.S. I am learning from the following youtube video.
https://www.youtube.com/watch?v=gR47cdxZibA
Raw data:
Table properties:
Data Import Wizard:
Data Import Wizard 2:
sqldeveloper
edited yesterday
Twisty Impersonator
17.8k146495
asked yesterday
Ombre
1
New contributor
Ombre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I am trying to import Excel data into a table in SQL Developer.
I have created table in SQL Developer. Then I use Data Import Wizard to import the Excel file into the table.
The problem comes when dealing with date/time information. See picture Data Import Wizard 2, I just can't seem to get the correct date/time format correct.
I think the format string should be DD/MM/YYYY HH:MM. But this doesn't work. My other attempts failed too.
Would appreciate any advice on this. Thank you.
P.S. I am learning from the following youtube video.
https://www.youtube.com/watch?v=gR47cdxZibA
Raw data:
Table properties:
Data Import Wizard:
Data Import Wizard 2:
sqldeveloper
sqldeveloper
edited yesterday
Twisty Impersonator
17.8k146495
asked yesterday
Ombre
1
New contributor
Ombre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited yesterday
Twisty Impersonator
17.8k146495
asked yesterday
Ombre
1
New contributor
Ombre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited yesterday
Twisty Impersonator
17.8k146495
edited yesterday
Twisty Impersonator
17.8k146495
edited yesterday
Twisty Impersonator
17.8k146495
17.8k146495
asked yesterday
Ombre
1
New contributor
Ombre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
Ombre
1
asked yesterday
Ombre
1
1
New contributor
Ombre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Ombre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Ombre is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
And the format field is not an input field where you can put dd/mm/yyyy HH12:mi ?
– Stian Yttervik
yesterday
So what should I do? Am I supposed to modify my data in Excel to fit the default formats?
– Ombre
yesterday
I would assume you use this to tell sql developer in what format the date you are importing is formatted in.
– Stian Yttervik
yesterday
add a comment |
And the format field is not an input field where you can put dd/mm/yyyy HH12:mi ?
– Stian Yttervik
yesterday
So what should I do? Am I supposed to modify my data in Excel to fit the default formats?
– Ombre
yesterday
I would assume you use this to tell sql developer in what format the date you are importing is formatted in.
– Stian Yttervik
yesterday
And the format field is not an input field where you can put dd/mm/yyyy HH12:mi ?
– Stian Yttervik
yesterday
And the format field is not an input field where you can put dd/mm/yyyy HH12:mi ?
– Stian Yttervik
yesterday
So what should I do? Am I supposed to modify my data in Excel to fit the default formats?
– Ombre
yesterday
So what should I do? Am I supposed to modify my data in Excel to fit the default formats?
– Ombre
yesterday
I would assume you use this to tell sql developer in what format the date you are importing is formatted in.
– Stian Yttervik
yesterday
I would assume you use this to tell sql developer in what format the date you are importing is formatted in.
– Stian Yttervik
yesterday
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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
});
}
});
Ombre is a new contributor. Be nice, and check out our Code of Conduct.
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%2fsuperuser.com%2fquestions%2f1390515%2foracle-sql-developer-load-excel-file-into-sql-server%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
Ombre is a new contributor. Be nice, and check out our Code of Conduct.
Ombre is a new contributor. Be nice, and check out our Code of Conduct.
Ombre is a new contributor. Be nice, and check out our Code of Conduct.
Ombre is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1390515%2foracle-sql-developer-load-excel-file-into-sql-server%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
And the format field is not an input field where you can put dd/mm/yyyy HH12:mi ?
– Stian Yttervik
yesterday
So what should I do? Am I supposed to modify my data in Excel to fit the default formats?
– Ombre
yesterday
I would assume you use this to tell sql developer in what format the date you are importing is formatted in.
– Stian Yttervik
yesterday