Store Array to Access w/o Parsing Each Row

[Trip]

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

[MGFoster]

-----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:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQ9AFEoechKq OuFEgEQKmqgCgkP BRdct/EzoRfHE2ie955FJ BMDsAn0I+
nNHUgJZsg8voQcQ xHLN+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?

[Stephen Lebans]

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" <tr**@consultan t.com> wrote in message
news:11******** **************@ g43g2000cwa.goo glegroups.com.. .

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