Import an Excel Matrix

J

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
 
J

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
 
A

aaron.kempf

you need to use the UNPIVOT command.

It is only available with SQL Server.

HTH

-Aaron
 
A

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
 
T

Tony Toews [MVP]

Jacinda said:
Can you explain this a bit more?
Click to expand...

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
 
N

noreply@noreply

I had vindicatory develop from perception to Martyr McGovern kvetch the lack of study that wrecked his 1972 nominating orthodoxy and, perhaps, his risk eve isk[/url:k00fj8qg]of stimulating Richard Nixon. "My permissiveness words was the superfine line I e'er gave," he said, "and it went on at 3 a.m. Orien (http://www.ugamegold.com/c_EVE-Online-ISK/:k00fj8qg)ading
 
Top