I am migrating about 4 gig of VFP data to SQL Server. I am using VFP COPY TO command, SQL Format Files, SQL BULK INSERT command being issued from VFP -> SQL via SQL Pass through.

When I bring in datetimes with the time element of 12:00:00 AM...when I view the table in the Enterprise Manager I do not see a time element in the corresponding datetime field. When I change the time element in the VFP Table to 12:00:01 AM (1 second past midnight) and redo the export import process...the time element shows up in the Enterprise Manager as it should as 12:00:01 AM.

Thanks Ron