CODEWITHSUNDEEP
csvsql-server-2008bcp
Kamran
Kamran

Reputation: 147

BCP into SQL Server with Tab Delimited

I am trying to import a csv file with tab delimited and I enter this bcp command it asks me to enter the column data type for every column. Any way I can edit this so I don't need to do this? Thanks!

bcp DW.dbo.ACSFlight \\gsc\Lib\Drop\Database\DataLoad\BCP_Files\ACSFlight_july2nd\ACSFlight705.dat -S JBBWIMDBS37 -T

Upvotes: 0

Views: 1500

Answers (1)

TT.
TT.

Reputation: 16146

Yes there is. Create a format file first using the bcp -format nul option. Once you have this format file, specify this format file in your import command using the -f format_file option.

Upvotes: 0

Related Questions