Results 1 to 4 of 4

Thread: pls help!!

  1. #1
    Join Date
    Nov 2004
    Posts
    5

    Unhappy Unanswered: pls help!!

    Hi all...I have got two questions,,, pls pls help me, my assignments are due shortly

    How can I create VIEW in microsoft access... and where, is it data defination query or union query

    CREATE VIEW Available_ Project
    AS SELECT course_id AS c_id,
    course_title AS c_name
    FROM Course

    I tried to execute the above code, it gives me error message ' syntax error CREATE TABLE'

    Secondly how can convert my table to a text file and then insert all the datas from the text file to a table, is there any sql expressions for tht??

    Any help will be greatly appreciated

  2. #2
    Join Date
    Dec 2004
    Location
    new york
    Posts
    28
    Quote Originally Posted by Mohsina
    Secondly how can convert my table to a text file and then insert all the datas from the text file to a table
    The best and most user friendly way to enter data into a table is using a form, try the form wizard which will help provide you with a better understanding of forms

  3. #3
    Join Date
    Nov 2004
    Posts
    5
    thnx for your reply. After posting my question in the forum i tried again and was able to export and import my data to and from the text file, but i could not create the view though....any suggestions???

  4. #4
    Join Date
    Dec 2004
    Location
    new york
    Posts
    28
    what kind of view do you want to display and what do you want to view?

Posting Permissions

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