how can i used inputbox in a query using vba

this code creates additional columns in particular (fixed)tablename in the Mysql

can i display input box to tell which table it should Add and ignore the duplicate columns

please let me know

Please Login or Register  to view this content.

Replace SQL line with

Please Login or Register  to view this content.

Ive just realised however that your SQL relates to altering a table structure rather than creating a new one, the logic is the same however in the Create Table SQL

thanks its working.

but it works only one time when i run macro

next time if i run it wouldnt display input box

another is that it will ask table name if it found any duplicate value

i have 25 columns after if add any thing it will go from starting column

please let ,me know