Results 1 to 10 of 10
  1. #1
    Join Date
    Oct 2005
    Posts
    6

    Unanswered: converting raw sql to access

    i have and .sql file that looks like it generates a table for a project. i'm very new to databases and i'm not sure how i use my ms access to "run" this code to create the database. please help!!!

  2. #2
    Join Date
    Jun 2004
    Posts
    27

    Talking

    Need A Sample File Will try To Work On

  3. #3
    Join Date
    Oct 2005
    Posts
    6

    attached is what i received from the company

    i'm okay with databases if i make them but not sure what to do with this. i think the one "define" file needs to be executed to create the data base but not sure how to do it. thanks for your help!!!


    most of the file sizes were huge so i had to delete some of the rows of contents.
    Attached Files Attached Files

  4. #4
    Join Date
    Jun 2004
    Posts
    27
    Hi There
    The Files You Sent Are Txt File And They Are Not To Create A Data Table If You Need To Import Them To Access Is Possible But It's HArd Work

    If You Want To Try Open A New Access mdb File And Choose Import From Menu Mark The File You Need And You Will Find Everything Is Self Explained....



    Sorry I Could Not Help You More



  5. #5
    Join Date
    Oct 2005
    Posts
    6

    the define file is actually a sql file

    check the mls_define file, it's the sql file

  6. #6
    Join Date
    Jun 2004
    Posts
    27
    You Are Right
    mls_define file is sql Script
    I Have Pasted To Query Analyzer In SQL And Generated the The Table Attached In An MDB Format

    But I Could Not Import Data In Txt Files As There Is No Fixed Delimited Or Fixed Width To Work On
    Attached Files Attached Files

  7. #7
    Join Date
    Oct 2005
    Posts
    6

    could you tell me how you did this?

    thanks so much for your help, can you tell me how you did this? thanks again!!!

  8. #8
    Join Date
    Jun 2004
    Posts
    27
    Hi There
    As I Mentioned Earlier The File mls_define is An SQL Script File.
    It is Like A code Than Can Be Read By The SQL Query Analyzer To Create Tables.

    The Script Has Command Lines That Tells Sql What Table To Create And What To Name It Also The Names Of The Fields That Should Populate The Table Created.

    To Be Able To Do It You Need To Have Sql Server On Your Machine

    After This Operation I Have Exported The Files To MDB Format That Can Be Read By MSAccess.

  9. #9
    Join Date
    Oct 2005
    Posts
    6

    Thanks!!!

    thanks!!! just what i was looking for!!!!
    you rock!!!

  10. #10
    Join Date
    Jun 2004
    Posts
    27

Posting Permissions

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