i see two issues:
first, teh data is so simple, i don't see any need to use a format file; i only use format files if it's delimited with quotes or something.
second, there's no path information for the files, so unless you actually placed them in the same folder that bcp.exe exists in, i'd expect it to fail.
bcp mydatabase.dbo.stg_assess_value in c:\Data\AVALUE.TXT -S myserver -U myusername -P mypassword -f c:\Data\Assess_Value.fmt
i would just switch to bulk insert for this one; i think it would be faster, and it's more TSQL-ish to me anyway.:
BULK INSERT stg_assess_value FROM 'c:\Data\AVALUE.TXT'
WITH (
DATAFILETYPE = 'char',
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n',
FIRSTROW = 1
)
Lowell