They exported data in the SQL Server native format (-n switch). It's only appropriate for transferring data between multiple instances of SQL Server because it stores all non-character data in internal SQL Server format. You've 2 options:
- Ask them to export data into ASCI format
- Install SQL Server and import data using the same BCP utility. The SQL Server Express edition is free and Developer Edition is very cheap.

>I've been provided from a client many files that were exported from their SQL Server database using the BCP utility, with matching format files for each table. The files have a .TXT extension but are not readable ASCII text. I need to somehow get this data into VFP tables.
>
>1. How can I tell what the format of these files is?
>2. How do I manipulate/convert it to be able to import into VFP?
>
>I need to do my work from VFP, as we don't have SQL Server here to do anything with the files.
>
>Here is the command the client used to pull one of the files:
>
>C:\WINDOWS\system32>bcp "SELECT * FROM [RE7].dbo.Appeal Where ( (0 = 0) Or (DateChanged >= Convert(varchar, DateAdd(d, -0, GetDate()), 101)))" queryout "D:\MSSQL\BACKUP\Masterworks Scripts\Output\Appeal.txt" -SRE-sQL -T -n
>
>And here is the command they used to create a format file:
>C:\WINDOWS\system32>bcp [RE7].dbo.Appeal format nul -S -T -n -f "D:\MSSQL\BACKUP\Masterworks Scripts\Output\Format_Appeal.txt"
>
>Thanks,
>Ron