Parse a Crosstab

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JimS - 07 Dec 2005 14:00 GMT

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?

Signature

Jim

Reply to this Message

Duane Hookom - 08 Dec 2005 02:42 GMT

"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.

Signature

Duane Hookom
MS Access MVP
--

>I have a table that has two key fields...
>
[quoted text clipped - 19 lines]
>
> Ideas?

Reply to this Message

JimS - 08 Dec 2005 03:44 GMT

I'm coming to that conclusion. Thanx.

Signature

Jim

> "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
[quoted text clipped - 23 lines]
> >
> > Ideas?

Reply to this Message