>Hi Kevin,
>
>>>I'm a little confused what you're trying to do...it looks like you're querying the temp table, one row at a time, and placing the columns from each row into a variable???
>>
>>I have upsized an Access table into SQL. I'm now going through all data and moving the data into normalized tables. I'm moving the data into variables so I can look tings up with other queries/sprocs.
>
>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.