Create Table in Sql Database using Access VBA

[danadams01]

I've spent the better part of today researching how to create a table in a SQL database via Access VBA. I can run a create table pass through query using the query tools, but when I convert it to code I get a "Data Type Conversion Error". Any and all help is appreciated.

Usually , you must use SQL manager app, create the table, THEN link it into Acces

 

[Gasman]

Usually , you must use SQL manager app, create the table, THEN link it into Acces

Isn't that what was said in Post 2 over 4 years ago?

 

[isladogs]

@Pat Hartman
The thread is 5 years old & was resurrected in post #21 by someone just copying the reply in post #2 (likely spammer?).
The OP has long since gone away