Click here to Skip to main content
15,120,326 members
Home / Discussions / Database
   

Database

 
AnswerRe: Sql Match Pin
OriginalGriff11-Oct-21 21:24
mveOriginalGriff11-Oct-21 21:24 
Question[Resolved] Need Help with this SQL Statement Pin
crmfghtr5-Oct-21 15:24
Membercrmfghtr5-Oct-21 15:24 
AnswerRe: Need Help with this SQL Statement Pin
Richard Deeming5-Oct-21 22:48
mveRichard Deeming5-Oct-21 22:48 
GeneralRe: Need Help with this SQL Statement Pin
crmfghtr6-Oct-21 3:37
Membercrmfghtr6-Oct-21 3:37 
GeneralRe: Need Help with this SQL Statement Pin
Richard Deeming6-Oct-21 4:36
mveRichard Deeming6-Oct-21 4:36 
GeneralRe: Need Help with this SQL Statement Pin
Eddy Vluggen8-Oct-21 16:23
professionalEddy Vluggen8-Oct-21 16:23 
General[Resolved] Re: Need Help with this SQL Statement Pin
crmfghtr10-Oct-21 17:18
Membercrmfghtr10-Oct-21 17:18 
QuestionImport CSV Problems Pin
Jörgen Andersson3-Oct-21 22:32
professionalJörgen Andersson3-Oct-21 22:32 
So, I'm trying to import Semicolon separated files into SQL Server.
The files are in codepage 1252 and are "Text Qualified" with a broken bar ¦

In the preview everything looks fine, but in the imported Tables all text fields looks like this: ¦text¦
This wouldn't be a big problem if it wasn't for the fact that some text fields contain semicolons.
Then some columns reads: ¦beginning of text , and the next one: end of text¦, and the last one might look like this: ¦¦;¦¦

If I'm saving the import as a dtsx package and open it in visual studio, the problem remains the same.

Is this a known bug or am I doing something wrong?
Any solutions that doesn't require me to create my own CSV-import?
Wrong is evil and must be defeated. - Jeff Ello

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 
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 

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.