Import an Excel Matrix

[Jacinda]

I was reading one of the posts "finding a value in a grid of numbers"
9/10/2005, I understand how to set this up in Access, How do I import the
data without having to retype the information again....

Here is what I'm doing: I have a chart that shows Diameter vs. Wire Type for
each one I have a price.. So

Wire Type
-------------------
Diameter| Price
|

This maxtix exists alreay in Excel, but now we want to use Access for our
calculation process... how do I get this into access? BTW, I have several
different types of similar matrix that are needed to provide quotes to my
customers.

- Jacinda

 

[Jeanette Cunningham]

Jacinda,
I did a quick search in the groups for "finding a value in a grid of
numbers".
I didn't find anything remotely like what you are describing.
It would be very helpful and save us volunteers valuable time if you would
post the URL of the link.
A question about the matrix: where did the matrix get its data from? I
assume it was not typed into a matrix by hand?
Do you have the worksheets that feed the values into the matrix?

Jeanette Cunningham

 

[aaron.kempf]

you need to use the UNPIVOT command.

It is only available with SQL Server.

HTH

-Aaron

 

[Jacinda]

http://www.microsoft.com/office/com...&p=1&tid=f73f82f5-6b39-413f-83ee-22391b6e282f

I believe the matrix was typed by hand... I don't have any other information
as to where the data came from. I have the charts all together in Excel, and
I'm now just trying to get all this info into Access withouth retyping it.

Thanks

 

[Jacinda]

Can you explain this a bit more?

you need to use the UNPIVOT command.

It is only available with SQL Server.

HTH

-Aaron

 

[aaron.kempf]

If you have the data in a matrix-- in Excel.

SalesPerson on the on the rows
Date on the columns

You can use the Unpivot command in order to turn this into a
normalized list that would say

SalesPerson Date Sales
Mark 1/1/2000 $12,000
Susie 12/1/2000 $10,000

You can take a matrix-- and convert it to a normalized list.

Just using one command. I just don't think that it is that easy in
Access; but SQL Server sure makes it a breeze

-Aaron

 

[Tony Toews [MVP]]

Can you explain this a bit more?

Be advised that Aaron's answer to every question involves SQL Server
and/or ADPs no matter how relevant his answer.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[??????]

???????

you need to use the UNPIVOT command.

It is only available with SQL Server.

HTH

-Aaron