Incorrect Syntax Near 'categories' - MSSQL Error

Discussion in 'Databases' started by dylanj, May 23, 2008.

0
  1. #1
    Hi there

    I'm having some trouble with this SQL statement:

    
rs.Open "CREATE TABLE [categories]", conn
    Code (markup):
    It's definitely not any of the other code - just this statement. Any ideas?

    Cheers
     
    dylanj, May 23, 2008 IP
  2. kmap

    kmap Well-Known Member

    Messages:
    2,215
    Likes Received:
    29
    Best Answers:
    2
    Trophy Points:
    135
    #2
    you have not mentioned the field names and their type

    Please refer a tutorial on SQL first

    Regards

    Alex
     
    kmap, May 24, 2008 IP
  3. dylanj

    dylanj Peon

    Messages:
    173
    Likes Received:
    3
    Best Answers:
    1
    Trophy Points:
    0
    #3
    Thanks, I figured it out :)
     
    dylanj, May 24, 2008 IP