sql server data warehouse: how difficult is it to convert access tables to SQL that can continue to be

Mike,
trivial....there is an Access Upsizing tool in Access that will convert
the data to MS SQL and then you can change your app to read these
tables via ODBC. If you have hard coded access to the tables in your
access app you need to change them to recordsets accessed via
ODBC....that's about it....when we did this on a small system many
years ago we got it done by a fresh uni grad and he only took a couple
of days.....

Peter