Adding a new column to an exisaiting SQL Database using VBA in Excel

[rv02]

Hi All
I was wondering whether anyone can help me with the following :

I want to add a new column to an existing external SQL database and I have the following code so far (I am new to this and not sure if this is the right way)

Please Login or Register  to view this content.

Is this correct way and if so what is the command in adding a new column (field) to the existinf database , I want to call the new column Brand which is text with 60 characters

Hope this is clear

Tanks in advance

[Kyle123]

Why do you want to do it in VBA? structural changes probably aren't best done here.

Nevertheless, it's just SQL so the syntax would be something like:

Please Login or Register  to view this content.

So:

Please Login or Register  to view this content.

Though you'd obviously need to swap the placeholders with actual values

[rv02]

Thanks for the reply. The reason I need to do it in VBA is because I have an excel spread sheet where the reporting is done and it contains lots of other macros and VBA codes.

I will try your suggestion

Tanks again

[Kyle123]

I think you're making a mistake, but I wis you all the best

[dflak]

See this article. It addresses MS-Query primarily but it has a section on rewriting SQL (the command string), "on the fly" using Excel Tables and the SUBSTITUTE command. I've even used this technique to switch from one database table to another within the same database, and used a model list on a spreadsheet to generate a bunch of "variable" IN statements for the SQL.

http://www.utteraccess.com/wiki/index.php/MS_Query