How Can I create a table by specifying tablename via inputbox

[tasawer]

Hi

my application creates a table using this code:

    strSql = "CREATE TABLE Output (Name Text, Month Number)"
    
    DoCmd.RunSQL strSql

I need to change the table name 'Output' by a name specified via inputbox, but i'm not sure how it can be achieved.
(something to this effect but it does not work)

    DIM tblName As String
    DIM strSql As Strng

    tblName=InputBox("Table Name")
    strSql = "CREATE TABLE '" & Output & "' (Name Text, Month Number)"
    
    DoCmd.RunSQL strSql

[TheSmileyCoder]

    tblName=InputBox("Table Name") 
    strSql = "CREATE TABLE " & tblName & " (Name Text, Month Number)"

[TheSmileyCoder]

You should consider adding some error handling code, in case user specifies an invalid table name, a blank string (closes inputbox wihtout typing anything) and so on.

[tasawer]

Hi Thank you for the suggestion.

obvioulsy my error was on using the apostrophe.

I am confused towards using the apostrophe in sql.
How can I know When to use it and when not to use it.

[missinglinq]

Our exalted leader, NeoPa, has an excellent tutorial on that very subject in the Insights section:

http://bytes.com/topic/access/insights/575414-quotes-double-quotes-where-when-use-them

Linq ;0)>