I have to load the ASCII file into a temp vfp table. Sort the temp table by effective date (create an index on the date field). Then post the transactions to a VFP table in effective date order.
>
>Does the application load the transactions into a VFP table/tables or is the final destination another database, like SQL Server?
Shane Murdoch