Parse a Crosstab

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that has two key fields...

System (Text)
SeqNbr (Text)
Hours (Integer)

Not every system has every SeqNbr. There's about 150 systems and about 50
sequence nbrs. The table is partly populated, but needs to be user-checked.

The most effective way for users to view this table is as a crosstab. I
create a crosstab query (SeqNbrs as columns, Systems as rows), and then they
scribble in their hours.

I want to let them use Excel to enter their data. I can easily export the
data to Excel, but I can't (short of a VBA program) figure out how to parse
out their input from the Excel spreadsheet back into the original table. I
can write the program, but I'd rather use a simpler tool if it's available.

Ideas?
 
"Simpler" is subjective. I would think the simplest automated method would
be to import the Excel worksheet and then use code to loop through the
records and fields to update the normalized table.
 
I'm coming to that conclusion. Thanx.
--
Jim


Duane Hookom said:
"Simpler" is subjective. I would think the simplest automated method would
be to import the Excel worksheet and then use code to loop through the
records and fields to update the normalized table.
Click to expand...
 
Back
Top