Results 1 to 2 of 2

Thread: Importing MsAccess To SqlServer Problem

  1. Mar 4th, 2002, 12:04 AM #1
    buddu
    buddu is offline

    Thread Starter
    Hyperactive Member buddu's Avatar
    Join Date
    Jul 2001
    Location
    India
    Posts
    446

    Importing MsAccess To SqlServer Problem

    Hi
    I am trying to importing the Access Tables and Queryes to Sql Server But I cannot eable to Import the Queryes. What could be the reason.
    Should I make the queryes as some seperate format?

    Please Help me.
    prasad
    Reply With Quote Reply With Quote
  2. Mar 4th, 2002, 04:09 AM #2
    PilgrimPete
    PilgrimPete is offline
    Frenzied Member PilgrimPete's Avatar
    Join Date
    Feb 2002
    Posts
    1,313
    Not too sure what you're trying to do with the queries; but I assume you are trying to import the SQL, since the data itself is stored in the other tables, and the query is just a view on this data...

    I don't think you'll be able to import the SQL, you may just have to use good old Copy and Paste to create new views and paste the SQl into them - not too bad if you don't have too many, a real pain if you have a lot (you could probably write a fairly simple piece of code to do it though...).
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width