Make table query with a union and linked table to update another table

[bryn30]

Goal - Pull data from Production DB and populate fields in an Operations DB.

First determine Orders to pull. so I created a Union Query to get a list of Orders.
Pull Data From Production. built a query using the Union query to pull three fields, Date1, Date2, Text1

I need to send this information to the operation DB but change the data type of the Text1 field to Integer.

Can anyone help me with the code to do this? what is the best way to accomplish this?

 

[tomschafer]

As long as you have all your queries together you can use the built in cint function to convert your text field to integer...

select
CInt(Text1)
from
......

 

[bryn30]

Thanks Pezamystik