Use variant in microsoft access.

[ChuckNorris]

Hi there.

I know this is not really a Labview question, but since it is a Labview program that is causing me problem I think it is okay to ask here aswell. I write aswell because I have tried other forums without succes...

From Labview I am using SQL tools to create a table in an MS Access database file. There is no problem in creating a table with severel columns of my choice, but I would like to create a column of the datatype VARIANT. This is because I need to store both numerical values and text in the same column. I get a syntax error when using the command:

CREATE TABLE TABLE1(Id COUNTER PRIMARY KEY, column1 SINGLE, column2 VARIANT)

The question that I have not been able find the answer to is: Am I doing it wrong or is it simply impossible to create a column of the datatype VARIANT?

[smercurio_fc]

Are you sure that you can actually create a column of type VARIANT in Access? As far as I know, you can't, but I'm no expert in Access. Perhaps you're thinking of the MEMO type? What does the documentation for Access say about the available data types for columns? Here's one link for types, and I don't see VARIANT in there.