Need to use data from mdb and sql dbs

[nelo]

Am I overlooking something really simple?

This is not easy to answer since you have not said what you have actuall done. You can use ADO.NET to query both Access and SQL Server databases. The only difference will be in the connection to each database. Everything else should be the same. Are you familiar with ADO.NET? There are many many samples on MSDN and elsewhere on the web.