SQL Data Import From Text Inserts All Fields into Single Column-CodePudding

Home > OS > SQL Data Import From Text Inserts All Fields into Single Column

SQL Data Import From Text Inserts All Fields into Single Column

Time：12-03

I have a txt file and the data looks like this

[value]~[value]~[value]~[value]~

When I try to use the SSMS import wizard to import into SQL Server, everything is put into one column and the ~* characters are included in the values (see image)

Page link：https//www.codepudding.com/os/214168.html

Prev:Use ActiveSupport::Cache::FileStore directly in a model class

Next:how to change the SQL script so that the columns with the amount are right-aligned

Tags：

sql-server

import

ssms

flat-file

Links：
CodePudding