Hello all,

Is there anyway to store an array to MS Access 2002 without parsing the
entire array row-by-row. For example, Oracle allows you to store BLOBs
(binary large objects). I would like to be able to say in VB/VBA

With rstName
.AddNew
!fieldName = ArrayName
.Update
.Close
End With

Any ideas?

Thanks!!

Trip

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

According to strict SQL design principles you shouldn't have more than
one item per cell (IOW, each array element should be in a separate
column).

But, if you insist.... Use the Split() function to break out each
element of the array into a comma-delimited string. E.g.:

!fieldName = Split(ArrayName, ",")

The comma in quotes indicates that the comma should be used sas the
element separator.

Make sure the column size can accomodate the resulting string.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQ9AFEoechKqOuFEgEQKmqgCgkPBRdct/EzoRfHE2ie955FJBMDsAn0I+
nNHUgJZsg8voQcQxHLN+HTEB
=scOO
-----END PGP SIGNATURE-----


Trip wrote:[color=blue]
> Hello all,
>
> Is there anyway to store an array to MS Access 2002 without parsing the
> entire array row-by-row. For example, Oracle allows you to store BLOBs
> (binary large objects). I would like to be able to say in VB/VBA
>
> With rstName
> .AddNew
> !fieldName = ArrayName
> .Update
> .Close
> End With
>
> Any ideas?
>[/color]

You can use the very same code you posted as long as the field was defined
as a Long Binary field. You are then working with a field defined as a BLOB.
There is code in the Acces help file and on the MS KB for reading and
writing BLOB fields but for small amounts of data that are not across a
Network I would simply use the came code/logic that you posted..

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Trip" <trip@consultant.com> wrote in message
news:1137704182.060582.158210@g43g2000cwa.googlegr oups.com...[color=blue]
> Hello all,
>
> Is there anyway to store an array to MS Access 2002 without parsing the
> entire array row-by-row. For example, Oracle allows you to store BLOBs
> (binary large objects). I would like to be able to say in VB/VBA
>
> With rstName
> .AddNew
> !fieldName = ArrayName
> .Update
> .Close
> End With
>
> Any ideas?
>
> Thanks!!
>
> Trip
>[/color]