Loading Property Historical Sales Field Value Key Data - property_historical_sales - Latest

Create the table structure in the database using the Create Table script found. Be sure to change the table name in the template to hist_field_value_key.

If a new format (FMT) file needs to be created, please follow the steps found in https://msdn.microsoft.com/en-us/library/ms191516.aspx.

bcp <database_name>.dbo.<table_name> format null -c -f <path>\format_file_name.fmt -t "|" -S -T

-T: Specifies that the bcp utility connects to SQL Server with a trusted connection using integrated security. If -T is not specified, the -U and -P parameters for username and password must be passed in order to log in.

-t "|": Specifies that the format file will be generated using the pipe character as a delimiter.

bcp PAD.dbo.hist_field_value_key format nul -c -f E:\PAD\
hist_field_value_key.fmt -t "|" -S -T