Unable to make columns using DB insert function?

[gbedi]

Hello, This the VI which I made but I am not able to make the columns in MS Access . I don't know why? If I delete the column array then it feeds the data into MS access not with the specified column?

[smercurio_fc]

Why are you telling it to create the table each time the loop iterates?

Why do you have a loop? The data never changes.

Why are you using so many global variables?
Why do you have the path hard-coded?

[gbedi]

Its a sub VI of a bigger program where it scans data. So this VI just has to write information into the database of my company. So that's why it has global variables and all other things but I just need to run this sub VI and then put some virtual information in it and then use it in the other program . Also I need to select the lot number feed information in that lot and then I need to select a different lot to create different information. And then I need to use db select to take out the specified information the user wants . So I was stuck in that things because it was not creating the columns in the MS access. I hope all these must have answer your questions.

[smercurio_fc]

If it's a subVI it makes even less sense to have it create the columns each time. The database and its table should already exist.