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

preview_player
Показать описание
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:

Link for SSIS Install

Link for SQL Server Install
Рекомендации по теме
Комментарии
Автор

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

aungthukkyaw
Автор

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

mestermester