Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Upsizing Access to SQL

Status
Not open for further replies.
TonyKhela

TonyKhela

Technical User
May 7, 2002
157
GB
Hi All,

I am having problems upsizing the Queries to sprocs.
The UPsizing wizard works well for tables and data, but does not show the queries in the wizard.

If I use the DTS Import of SQL Server 2000, the Queries show as VIEWS but are converted to Tables not Sprocs.

What I really want is the queries code to be converted to sprocs.

Does anyone know of a tool that will do this?

Any help appreciated.

Aasim
 
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Field size limit Access 365
Replies
5
Views
2K
TrekBiker
TrekBiker
Anthony343242
  • Locked
  • Question
MS ACCESS UNION ALL with Attachment data type 1
2
Replies
29
Views
4K
Anthony343242
Anthony343242
03Explorer
  • Locked
  • Question
Refreshing a linked table (housed on MS SQL Server) now breaks
Replies
3
Views
350
dhookom
dhookom
MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
387
SkipVought
S
ameedoo3000
  • Locked
  • Question
Send a message to an email
Replies
2
Views
2K
ameedoo3000
ameedoo3000

Part and Inventory Search

Sponsor

Back
Top