>>I am not answering your question here but asking one. I may be needing to do exactly what you are doing now as I am looking at an absolutely terrible app written in Access and evaluating re-doing it. The data is completely un-normalized and I would move it to SQL. What is the general process you used to get the data from Access to SQL? Is this a routine that is easily repeatable? I would need to do it once for my development and again just before deploying the new application.
>>Thanks
>>Tim
>
>So far what I have done is use the Upsizing wizard in Access to get all 4 tables into SQL. They have similar structures. Then in SQL I created a query for each one, aliasing the column names so all 4 have the same structure. UNION doesn't work because there are
>some ntext fields.
>
>Now that I have all 4 into tables with the same structure, I can iterate through the rows and insert the data into normalized tables.
Thanks. I just did some testing to convert to VistaDB and found I had to change the SmallDateTime fields to regular DateTime fields. I will test to SQL next.
Tim
Timothy Bryan