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
Timothy Bryan