How do I import a CSV file into SQL Server with Billy Thomas, ALLJOY Data

แชร์
ฝัง
  • เผยแพร่เมื่อ 25 ส.ค. 2024
  • This video will walk you through using the SQL Server import and export wizard to import a CSV file into a SQL Server database.
    Link for Sample File:
    www.datablist....
    Link for SSIS Install
    • SQL Server SSIS Instal...
    Link for SQL Server Install
    • How to install SQL Ser...

ความคิดเห็น • 3

  • @aungthukkyaw15
    @aungthukkyaw15 9 หลายเดือนก่อน +1

    This is really working after surfing hundreds of videos on youtube. Appreciate it.

  • @mestermester6749
    @mestermester6749 6 หลายเดือนก่อน

    What happens if in that case the delimiter is the comma "," but you have a column that internally has commas? For example "x value, y value, z value,"... the SQL divides this field into columns and it would be wrong because "it interprets the delimiter of said column as new columns", how is this fixed? Thank you!!!

    • @alljoydata
      @alljoydata  6 หลายเดือนก่อน

      Sorry for the lat reply. I would open the file in excel and then save it as a tab delimited and then import to SQL as Tab delimited