I have a large query that is built in SQL server and I need to query a table that is in an Access database. Is there any way to do this without using OPENROWSET() which is disabled by my DBA? I can't figure out the import wizard and copy pasting the actual rows into a temporary table won't work bc it's over 50k rows. I have a bad feeling the only solution is creating a linked table to SQL server from Access and rewriting my query. Continue reading...