Just good old inserts from VFP - one line at a time - probably not the fastest way, but I wasn't dealing with ton's of data and it gave me a lot of control in a language I'm very familiar with. I even had all the triggers, etc. set-up in SQL beforehand so that all data got "validated" as I went. I wouldn't have done that if it had been a huge amount of data or I had to do it at more than justa few companies.
Ken
>Ken--
>Thank you for the descriptive success story! I'd like to try something similar myself soon.
>
>I find myself wondering how you loaded your initial data into SQL Server. Did you use BCP? If you used INSERT INTO, did you do anything special to write the INSERT INTO statement?
Ken B. Matson
GCom2 Solutions