check if column exist

[xopherira]

How do I check to see if column exist before adding it. New to VBA and having a problem testing for this condition.



Public Sub keyColumn()

DoCmd.RunSQL ("ALTER TABLE 3BSM_bom_template " & "ADD keyColumn COUNTER;")

End Sub

[June7]

A db design that requires routine modification of table (adding fields) is probably not a normalized structure.

Why do you need to programmatically add field? Why not just open table in design view and modify?

Checking if field exists will probably require looping through table Field Collection.

Bing: Access VBA does field exist in table

http://forums.devarticles.com/micros...vba-58559.html

[xopherira]

Its not a db per say. Im importing a very complicated spreadsheet and using access to manipulate with another spreadsheet. The structure of spreadsheets can not be changed.

[June7]

This is a periodic event?

[xopherira]

ONce a week at the most.

[InsuranceGuy]

If you're still wanting to check whether fields exist within a table, you'll want to take a look at the TableDefs DAO structures.

You may also want to look at PowerQuery in Excel, depending on what you're trying to accomplish.