>How do I move records from a VFP table in a DBC into an SQL table?? Using VFP 6 and SQL 7.
>
>I have the DBF in the DBC with the exact same fields as the SQL table.
>
>I tried to append from that DBF and it dies after one record saying that a certain field can not be blank (null) , but it is NOT blank in the DBF.
>
>I tried to scatter memvar then Insert into the SQL table (a remote view in the DBC) and it insert one record FINE, but always dies on the SECOND record it does not allow nulls (but there IS data in the DBF field for record 2).
>
>
>HELP!!!!!!!!!!
Joel,
Since you already have the structure in SS 7, I recommend using Data Transformatino Services (DTS). From Enterprise Manager, select Databases under your server. Right-click and select All Tasks - Import Data. Follow the wizard in selecting the SS database, the VFP source, tables, etc.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao