migration from access database completely to query for a report

• fadewumi

  SSC Journeyman

  Points: 84

  More actions

  January 15, 2015 at 6:59 am

  #294380

  guys, i need help , am new as a dba and we use Access database , and we want to completely do away with access, on my report tool,which is crystal report, we want query to be our data source so , we do not want to use ssis packageor import from access to sql, how can l handle bringing all table and the query from Access together ,

• serg-52

  SSCrazy Eights

  Points: 9913

  More actions

  January 15, 2015 at 7:26 am

  #1770451

  In Management Studio you may use Expot and Expot Wizard to import data from Access.

  Next your queries may be saved as stored procedures or views or TVFs. But i think you'll need to refactor them to incorporate useful T-SQL features.