I want to create a table from VBA code like this example:
Dim MySQL As String
MySQL = "CREATE TABLE exTable (ID integer, Name text (50))"
My problem is i don't know which datatype i should use to create a memo field or how to create an autonumber field.
How many way to create a table automatically through VBA?
Thanks for you answers and please excuse my english.