-----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:
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?