assign variable in Macro (2000 and up)

[dvdweir]

I have a database that I import files to

[HansV]

The target of a MakeTable query cannot be a variable name. You'd have to change the SQL text of the query, or assemble the SQL string and execute it. I would use VBA for this, not a macro (but you can call the VBA code from a macro if you wish).

Sub MakeATable()
Dim strName As String
Dim strSQL As String
strName = InputBox("Enter the name")
If strName = "" Then
MsgBox "No name specified.", vbCritical
Exit Sub
End If
' Just an example
strSQL = "SELECT [Field1], [Field2], [Field3] INTO [F_" & strName & "] FROM CurList"
DoCmd.RunSQL strSQL
End Sub