Alex A
asked on
SQL Server 2008: loading table from the pipe delimited file
What is the quickest way to load data in the table from the flat file?
Table has more columns than the file, which should be ignored.
Table has more columns than the file, which should be ignored.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Well, it is a CSV file. That is unless you think that the only CSV is a comma delimited file.