Help: convert a Variant data into an Access table

  • Thread starter Thread starter coolfa
  • Start date Start date
C

coolfa

Hi all. May I ask a question here? I am modifying data which was
developed by some other guys a long time ago. They get all needed data
into an Variant variable, say AVariant, which includes headers in the
first record and data from the second one. Originally they copy the
Avariant into a spreadsheet range variable to store them there. Now I
am trying to directly create an access table from this AVariant. The
columns will be extracted from the first record of this AVariant and
then the data afterwards. I know I am a newbie on Access so I ask for
help here. Would someone kindly provide any clue? Thanks a lot and have
a great afternoon.

Best
Coolfa
 
Hi Coolfa,

Since a Variant can hold anything, this doesn't give enough to go on. Does
AVariant contain a recordset (which kind?), an array (dimensions? data
types?), a collection or dictionary, a formatted string, or what?
 
Back
Top