We have a process (non-VFP) that runs on a SQL Server machine that generates a text file once a day that we wind up importing into a VFP free table via a VFP 6 app. The problem is that the text file uses Unicode characters which means that two bytes are used for each character. Currently, we have to open the text file in Notepad on a Windows XP box and save it using the ANSI encoding option. Once we save it using ANSI encoding the file size is cut in half and we can then import the text file into our table.

Is there a tool/program available that we can use to remove the manual opening/saving process we use currently?

Ultimately I'd like to be able to do the SQL Server query within the VFP app directly but I don't have any experience using VFP and SQL Server. I'm probably the only person that still does anything in our IT department with FP/VFP. We have people that do that kind of thing in VB but I'd rather stick with VFP. I have access to the VB code used to get the data I can use as a starting point. If anyone has some articles I could read on how to do SQL Server (I think it's SQL Server 2000) queries with VFP I'd love to read them. I have used SQL queries on native FPW tables a lot but I haven't used any of the SQL features added in VFP 6.

Any help would be greatly appreciated.