Click here to Skip to main content
15,125,273 members
Home / Discussions / Database
   

Database

 
AnswerRe: Import CSV Problems Pin
Mycroft Holmes4-Oct-21 13:12
professionalMycroft Holmes4-Oct-21 13:12 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson4-Oct-21 21:24
professionalJörgen Andersson4-Oct-21 21:24 
AnswerRe: Import CSV Problems Pin
CHill604-Oct-21 22:04
mveCHill604-Oct-21 22:04 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson4-Oct-21 22:13
professionalJörgen Andersson4-Oct-21 22:13 
GeneralRe: Import CSV Problems Pin
CHill604-Oct-21 22:34
mveCHill604-Oct-21 22:34 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson4-Oct-21 22:43
professionalJörgen Andersson4-Oct-21 22:43 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson4-Oct-21 23:04
professionalJörgen Andersson4-Oct-21 23:04 
AnswerRe: Import CSV Problems Pin
Richard Deeming4-Oct-21 23:04
mveRichard Deeming4-Oct-21 23:04 
Have you tried using the "Import Flat File" wizard, instead of the "Import/Export Data" wizard? It's supposed to be better at this sort of thing...

Import Flat File to SQL - SQL Server | Microsoft Docs[^]

Otherwise, you might need to resort to Powershell or C#.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: Import CSV Problems Pin
Jörgen Andersson4-Oct-21 23:11
professionalJörgen Andersson4-Oct-21 23:11 
GeneralRe: Import CSV Problems Pin
Richard Deeming5-Oct-21 0:12
mveRichard Deeming5-Oct-21 0:12 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson5-Oct-21 2:17
professionalJörgen Andersson5-Oct-21 2:17 
AnswerRe: Import CSV Problems Pin
RedDk5-Oct-21 9:11
MemberRedDk5-Oct-21 9:11 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson6-Oct-21 0:33
professionalJörgen Andersson6-Oct-21 0:33 
QuestionWHERE NOT EXIST QUERRY Pin
remiki13-Sep-21 6:00
Memberremiki13-Sep-21 6:00 
AnswerRe: WHERE NOT EXIST QUERRY Pin
Richard Deeming13-Sep-21 6:58
mveRichard Deeming13-Sep-21 6:58 
AnswerRe: WHERE NOT EXIST QUERRY Pin
remiki13-Sep-21 7:02
Memberremiki13-Sep-21 7:02 
QuestionDatabase programming Pin
Member 1535340410-Sep-21 0:54
MemberMember 1535340410-Sep-21 0:54 
AnswerRe: Database programming Pin
Richard MacCutchan10-Sep-21 1:27
mveRichard MacCutchan10-Sep-21 1:27 
QuestionHow to design sql db for storing Name/Value objects with unknown value type (EF Core 5 as ORM)? Pin
Member 146377867-Sep-21 1:43
MemberMember 146377867-Sep-21 1:43 
Rant[REPOST] How to design sql db for storing Name/Value objects with unknown value type (EF Core 5 as ORM)? Pin
Richard Deeming7-Sep-21 2:00
mveRichard Deeming7-Sep-21 2:00 
QuestionWhy not to use NoSQL instead of RMDBS? (not Mongo) Pin
Hopeless Idealist14-Aug-21 2:21
MemberHopeless Idealist14-Aug-21 2:21 
AnswerRe: Why not to use NoSQL instead of RMDBS? (not Mongo) Pin
Mycroft Holmes14-Aug-21 13:36
professionalMycroft Holmes14-Aug-21 13:36 
AnswerRe: Why not to use NoSQL instead of RMDBS? (not Mongo) Pin
jschell5-Sep-21 10:07
Memberjschell5-Sep-21 10:07 
QuestionSql query , comparing a table field to a list of values , condition (MS SQL) Pin
zira178929-Jul-21 16:32
Memberzira178929-Jul-21 16:32 
AnswerRe: Sql query , comparing a table field to a list of values , condition (MS SQL) Pin
Richard MacCutchan29-Jul-21 22:15
mveRichard MacCutchan29-Jul-21 22:15 

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.