How to create a table for Access database in the VB.net vs2019

Question

hi .

        Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=MyPath.accdb;"
        Using connection As New OleDbConnection(connectionString)
            Try
            connection.Open()
             dim SqlCreator as string="Create Table Table1" & vbNewLine &
             "Column1 Text(50)"
             ' What should I do to create the table?
            Catch ex As OleDbException
               
            Finally
                connection.Close()
            End Try
      End Using

Answer 1

dim SqlCreator as string="Create Table Table1" & vbNewLine & "Column1 Text(50)" ' What should I do to create the table?

Use an OleDbCommand to execute a SQL statement

https://learn.microsoft.com/en-us/dotnet/api/system.data.oledb.oledbcommand?view=dotnet-plat-ext-7.0

and moreover, use the correct SQL syntax to create a table:

https://www.w3schools.com/sql/sql_create_table.asp