Results 1 to 5 of 5

Thread: Temporary Table

  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Temporary Table

    How can i create temporary table in the Modules?

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    A simple way would be to use the SQL CREATE TABLE statement:
    Code:
    Dim SQLstrg As String
    SQLstrg = "CREATE TABLE table_name (column_name1 data_type, column_name2 data_type, ...and so on....)
    DoCmd.RunSQL SQLStrg
    He is a small SQL tutorial document for you. You can view it with MS WORD.


    .
    Attached Files Attached Files
    Last edited by CyberLynx; 10-24-05 at 07:23.
    Environment:
    Self Taught In ALL Environments.....And It Shows!


  3. #3
    Join Date
    Sep 2005
    Posts
    313
    The file is blank. Nothing

  4. #4
    Join Date
    Nov 2003
    Posts
    1,487
    Oh brother....
    Environment:
    Self Taught In ALL Environments.....And It Shows!


  5. #5
    Join Date
    Nov 2003
    Posts
    1,487
    I have resent the file above. Hopefully it's OK now. Please let me know if there is a problem.



    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


Posting Permissions

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