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...
This is really working after surfing hundreds of videos on youtube. Appreciate it.
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!!!
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