Click to See Complete Forum and Search --> : Put a variant in an Access database


F.Mayis
August 9th, 2001, 09:45 AM
Hi,
Is it possible to create a field in an Access database table that as a variant.

i just need to put Booleans, floats, longs, strings, but i don't want to have each fields of this type defined in my table.

Thanks a lot!

GeorgeT
August 9th, 2001, 09:57 AM
Use text data type, read data then convert it to any data type you want using converting functions

F.Mayis
August 9th, 2001, 10:10 AM
Quite slow, isn't it?

But if there is no other way it's a good tip!