replicating action queries in sql server

[Guest]

i'm currently moving from an mdb to an sql database (using MSDE Sql Server 7)
i have used dts to import data tables.

what is the best approch to replicate access action and union queries in the
server enviroment?
can i use the sql behind these queries in stored procedures? (i'm new to sp)
or is there another way?

Thanks for your help
luzippu

 

[[MVP] S.Clark]

The upsizing wizard might help. Tools / Database / Upsize

If not, copy and paste is always an option.

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html