When you say you want this stored as a scalar, and assuming you've got multiple records, how do you want to preserve the relationship in the data? There are various method to do this however what you've got here looks pretty good IMO.
Having never worked with MS Access and the DBI, I cant comment on how (or if) it actually works, however if it works the same as a "regular" ole DBI supported database, i'd be using a simple sql and placeholders to insert this data into your database.
There are many nodes here you can lookup examples for...
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|