By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,574 Members | 2,966 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,574 IT Pros & Developers. It's quick & easy.

Store Array to Access w/o Parsing Each Row

P: n/a
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

Jan 19 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
-----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?

Jan 19 '06 #2

P: n/a
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**@consultant.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.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

Jan 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.