csv columns as rows in tables

[Renster]

Folks,

Forgive me if this is a bit vague, but it's been a while since I did
anything with Access, and Im not sure I can accurately describe what Im
trying to achieve here, but here goes!

We have a system that on every run, re-creates a CSV with 16 data rows,
something like:

Field,Value
field1,20
field2,25
field3,15
field4,45
....
field16,10

I have an access database, that, among other tables, has "run" and
"results" tables. Each of those 2 tables has a number of fields, the
last 16 of which are to be populated from the csv - the last 16 fields
in the run table are to be filled with the "csv field", and the results
with the "csv value". This is all to be done (probably*) on the click
of a button on an access form, at which point the other fields in the
run/results records will be populated based on lookups on yet more
tables etc. Anyway, before I stray from the point, can someone offer
some guidance on how to write the update / insert part of a query to
set the Nth field of a table to the Nth Row, 1st/2nd column of an
external csv?

Is this even possible?

Many thanks in advance

* = Because management's indecision (as to what is actually wanted) is
final.

 

[John Nurick]

Hi Renster,
Consider using the TransposeTextFile() function at
http://www.j.nurick.dial.pipex.com/Code/index.htm to convert the file
into something you can import using any of the usual techniques.

 

[Renster]

Thanks John,

Quite a handy bit of code that. Now all I need to do is get Management
to make a decision about anything! ;-)

Steve