>>Once you create your SQL database, you can create a RV against it and just append from your local tables.
>
>
>JR:
>
>I need the data to go the other way but I have a SQL version problem to deal with. Thanks for the input.
>
>--rab

Why not set the compatibility level of SQL Server 2000 (8.0) to 7.0?