How to import ACCESS Query to SQL 2005?

[weldrick]

Hi!
I'm using the SQL DTS to upsize access database to SQL 2005. It imports tables properly, but for queries, it imports the query output to SQL 2005 as a table . What I want is just to import the query text as a view in SQL 2005.

How can I do this? Suggestions, ideas will be appreciated.

weldrick

 

[mrdenny]

You'll probably have to do it manually, or use the MS Access upsizing wizzard. It should be available from

http://www.microsoft.com

somewhere.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com