Folk,
I have a table of data which changes monthly and is used to update the main table on a monthly basis. The table containing the data to be updated has various columns defined as Number, Text or Date.
During the update process in VBA, when number or date data is read into a VBA variable defined as Variant it's converted to a text enclosed in quotes.
Is this a quirk of using a Variant? I use that type because of the type variation in the import data. I was unaware that Variant type converts everything to text. I suppose I assumed (bad) that Variant would keep the type of what is read into it.
Thanks,
Vic
I have a table of data which changes monthly and is used to update the main table on a monthly basis. The table containing the data to be updated has various columns defined as Number, Text or Date.
During the update process in VBA, when number or date data is read into a VBA variable defined as Variant it's converted to a text enclosed in quotes.
Is this a quirk of using a Variant? I use that type because of the type variation in the import data. I was unaware that Variant type converts everything to text. I suppose I assumed (bad) that Variant would keep the type of what is read into it.
Thanks,
Vic