Click here to Skip to main content
14,640,158 members
Home » Discussions » Database
   

Database

 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
jschell26-Dec-17 7:39
Memberjschell26-Dec-17 7:39 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
User9874314-Jan-18 10:44
professionalUser9874314-Jan-18 10:44 
SuggestionRe: OLE DB Data Types to C# Data Type Mapping Pin
Richard Deeming8-Jan-18 7:38
mveRichard Deeming8-Jan-18 7:38 
GeneralRe: OLE DB Data Types to C# Data Type Mapping Pin
User9874314-Jan-18 10:50
professionalUser9874314-Jan-18 10:50 
QuestionT-SQL and denomalization of Parent and Child hierarchy Tables Pin
Member 1358789920-Dec-17 21:41
MemberMember 1358789920-Dec-17 21:41 
AnswerRe: T-SQL and denomalization of Parent and Child hierarchy Tables Pin
Victor Nijegorodov21-Dec-17 1:54
MemberVictor Nijegorodov21-Dec-17 1:54 
QuestionTo convert an Excel file to CSV and then move that data from CSV to oracle database. Pin
sai.201218-Dec-17 8:23
Membersai.201218-Dec-17 8:23 
AnswerRe: To convert an Excel file to CSV and then move that data from CSV to oracle database. Pin
jschell18-Dec-17 15:51
Memberjschell18-Dec-17 15:51 
If it is one time...
1. You can save the file as CSV. Do a "save as" and then pick the 'type' via the drop down.
2. Then as noted you can use sqlloader.

If you must automate this to do it over and over then there are other problems you did not touch on like how you know there is a new file and how to recognize an update versus new.

But at any rate it is possible to read an excel file via an "ODBC" driver. I believe this is still possible, once you track down the driver. This would with very simple Excel files.
QuestionRe: To convert an Excel file to CSV and then move that data from CSV to oracle database. Pin
Richard MacCutchan18-Dec-17 21:35
mveRichard MacCutchan18-Dec-17 21:35 
QuestionMicrosoft SQL Server VS PostgresSQL Pin
Zeyad Jalil18-Dec-17 0:02
professionalZeyad Jalil18-Dec-17 0:02 
AnswerRe: Microsoft SQL Server VS PostgresSQL Pin
Nathan Minier18-Dec-17 1:13
professionalNathan Minier18-Dec-17 1:13 
AnswerRe: Microsoft SQL Server VS PostgresSQL Pin
jschell18-Dec-17 15:52
Memberjschell18-Dec-17 15:52 
QuestionOverwrite from DB as windows Services Pin
Member 1204258517-Dec-17 18:46
MemberMember 1204258517-Dec-17 18:46 
AnswerRe: Overwrite from DB as windows Services Pin
Victor Nijegorodov17-Dec-17 20:54
MemberVictor Nijegorodov17-Dec-17 20:54 
QuestionBuying of referrals Pin
Member 1357942916-Dec-17 0:13
MemberMember 1357942916-Dec-17 0:13 
AnswerRe: Buying of referrals Pin
Richard MacCutchan16-Dec-17 0:49
mveRichard MacCutchan16-Dec-17 0:49 
GeneralRe: Buying of referrals Pin
Member 1357942916-Dec-17 2:41
MemberMember 1357942916-Dec-17 2:41 
GeneralRe: Buying of referrals Pin
OriginalGriff16-Dec-17 2:43
mveOriginalGriff16-Dec-17 2:43 
QuestionSybase query returns blank/empty for char fields Pin
Member 1354244115-Dec-17 6:56
MemberMember 1354244115-Dec-17 6:56 
AnswerRe: Sybase query returns blank/empty for char fields Pin
jschell16-Dec-17 9:06
Memberjschell16-Dec-17 9:06 
GeneralRe: Sybase query returns blank/empty for char fields Pin
Member 1354244117-Dec-17 1:33
MemberMember 1354244117-Dec-17 1:33 
GeneralRe: Sybase query returns blank/empty for char fields Pin
Member 1354244119-Dec-17 13:36
MemberMember 1354244119-Dec-17 13:36 
GeneralRe: Sybase query returns blank/empty for char fields Pin
Member 1354244121-Dec-17 14:09
MemberMember 1354244121-Dec-17 14:09 
QuestionNeed a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Schudi12-Dec-17 3:27
MemberSchudi12-Dec-17 3:27 
AnswerRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Richard MacCutchan12-Dec-17 5:35
mveRichard MacCutchan12-Dec-17 5:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.