Conversion of Excel Matrix

I guess my message didn't come through how I had it laid out. My replies to
people below.

"Karl Dewey" wrote:

Crosstab query.

A crosstab query shows summary data, which is not what I am looking for.


"Gina Whipp" wrote:

Runnik,

You can DISPLAY data in a report ALMOST any way you like. (There are
exceptions but not many.) It all depends on how your tables are set up.
(There is also an option to link to Excel which MIGHT work better for you.)
If you provide us with some Data Models (table set up and relationships) we
can give you options for FREE. Please note, when I say WE I mean everyone
EXCEPT Steve.

Link to Excel how? I've got a lot built up already, and I'm not sure I could
adequately describe it all in writing. I was hoping I'd be able to post
attachments in this forum, but I guess I can't.


"Keith Wilby" wrote:

Can I ask why you would want to do this? Maybe you are under the impression
that Access is a beefed up Excel, which it most certainly isn't. If excel
does the job then I'd say stick with it.

I know the two programs are used for different purposes. I inherited a mess
of a spreadsheet, and I thought a database would be a better application, so
I wanted to convert it. In Excel, I am running out of columns (256 is the max
#). Yes, I could transpose all the data in it, but there's also the problem
of not being able to link a couple tabs together that need to be linked.
Thus, my wanting to put the data in Access. Maybe I need to rethink the
layout of the data, and find another way that works for what I need.

"Runnik" wrote in message
...

Maybe I need to rethink the
layout of the data, and find another way that works for what I need.

I would certainly agree with that, although my experiences of normalising
hugely complex Excel spreadsheets are not happy ones.

Keith.
www.keithwilby.co.uk

Runnik,

Yeah, we frown on attachments anyway... Perhaps you could post it to a web
page we could have a look at and see if your data is better off in Excel or
Access.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Runnik" wrote in message
...
I guess my message didn't come through how I had it laid out. My replies to
people below.

"Karl Dewey" wrote:

Crosstab query.

A crosstab query shows summary data, which is not what I am looking for.


"Gina Whipp" wrote:

Runnik,

You can DISPLAY data in a report ALMOST any way you like. (There are
exceptions but not many.) It all depends on how your tables are set up.
(There is also an option to link to Excel which MIGHT work better for
you.)
If you provide us with some Data Models (table set up and relationships)
we
can give you options for FREE. Please note, when I say WE I mean everyone
EXCEPT Steve.

Link to Excel how? I've got a lot built up already, and I'm not sure I
could
adequately describe it all in writing. I was hoping I'd be able to post
attachments in this forum, but I guess I can't.


"Keith Wilby" wrote:

Can I ask why you would want to do this? Maybe you are under the
impression
that Access is a beefed up Excel, which it most certainly isn't. If
excel
does the job then I'd say stick with it.

I know the two programs are used for different purposes. I inherited a
mess
of a spreadsheet, and I thought a database would be a better application,
so
I wanted to convert it. In Excel, I am running out of columns (256 is the
max
#). Yes, I could transpose all the data in it, but there's also the
problem
of not being able to link a couple tabs together that need to be linked.
Thus, my wanting to put the data in Access. Maybe I need to rethink the
layout of the data, and find another way that works for what I need.

Do you have any good suggestions on a website I could upload the file to?

"Gina Whipp" wrote:

Runnik,

Yeah, we frown on attachments anyway... Perhaps you could post it to a web
page we could have a look at and see if your data is better off in Excel or
Access.

--
Gina Whipp

I have never used such websites though I have seen it done from time to
time. Perhaps someone will step in with where you could do that.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Runnik" wrote in message
...
Do you have any good suggestions on a website I could upload the file to?

"Gina Whipp" wrote:

Runnik,

Yeah, we frown on attachments anyway... Perhaps you could post it to a
web
page we could have a look at and see if your data is better off in Excel
or
Access.

--
Gina Whipp

You made the statement:

"Is there a way do display my data like this in Access? If so, how? The
reason I'd like to have it in Access is that the spreadsheet is not large
enough to contain all the required data."

The answer is Yes! You made the correct assertion that Access is more suited
to your application than Excel. It doesn't take a rocket scientist to see
this from the example you gave. The other responder is wasting your time
trying to get you to upload your data to a website to see if your data is
better off in Excel or Access. You already have smartly determined that!!!
Let me setup the Access application for you and get you up and running as I
previously offered.

Steve





"Runnik" wrote in message
...
Do you have any good suggestions on a website I could upload the file to?

"Gina Whipp" wrote:

Runnik,

Yeah, we frown on attachments anyway... Perhaps you could post it to a
web
page we could have a look at and see if your data is better off in Excel
or
Access.

--
Gina Whipp

"Steve" schreef in bericht
m...
You made the statement:

"Is there a way do display my data like this in Access? If so, how? The
reason I'd like to have it in Access is that the spreadsheet is not large
enough to contain all the required data."

The answer is Yes! You made the correct assertion that Access is more suited to your
application than Excel. It doesn't take a rocket scientist to see this from the example
you gave. The other responder is wasting your time trying to get you to upload your data
to a website to see if your data is better off in Excel or Access. You already have
smartly determined that!!! Let me setup the Access application for you and get you up
and running as I previously offered.

Steve



--
Get lost $teve. Go away... far away....
I mean: Go ... go ...go

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html

Arno R

Except this time, stevie will do it for FREE.

John... Visio MVP
"Steve" wrote in message
m...
You made the statement:

"Is there a way do display my data like this in Access? If so, how? The
reason I'd like to have it in Access is that the spreadsheet is not large
enough to contain all the required data."

The answer is Yes! You made the correct assertion that Access is more
suited to your application than Excel. It doesn't take a rocket scientist
to see this from the example you gave. The other responder is wasting your
time trying to get you to upload your data to a website to see if your
data is better off in Excel or Access. You already have smartly determined
that!!! Let me setup the Access application for you and get you up and
running as I previously offered.

Steve





"Runnik" wrote in message
...
Do you have any good suggestions on a website I could upload the file to?

"Gina Whipp" wrote:

Runnik,

Yeah, we frown on attachments anyway... Perhaps you could post it to a
web
page we could have a look at and see if your data is better off in Excel
or
Access.

--
Gina Whipp

Steve wrote:
You made the statement:

"Is there a way do display my data like this in Access? If so, how? The
reason I'd like to have it in Access is that the spreadsheet is not large
enough to contain all the required data."

The answer is Yes! You made the correct assertion that Access is more suited
to your application than Excel. It doesn't take a rocket scientist to see
this from the example you gave. The other responder is wasting your time
trying to get you to upload your data to a website to see if your data is
better off in Excel or Access. You already have smartly determined that!!!
Let me setup the Access application for you and get you up and running as I
previously offered.


Of course, if he's smart, he can set it up himself... and kill two birds
with one stone - set up his database the way he wants it, and learn something
in the process.

--
Message posted via http://www.accessmonster.com

Guys... he previously offered to be paid!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"StopThisAdvertising" StopThisAdvertising@Data**** wrote in message
...

"Steve" schreef in bericht
m...
You made the statement:

"Is there a way do display my data like this in Access? If so, how? The
reason I'd like to have it in Access is that the spreadsheet is not large
enough to contain all the required data."

The answer is Yes! You made the correct assertion that Access is more
suited to your application than Excel. It doesn't take a rocket scientist
to see this from the example you gave. The other responder is wasting
your time trying to get you to upload your data to a website to see if
your data is better off in Excel or Access. You already have smartly
determined that!!! Let me setup the Access application for you and get
you up and running as I previously offered.

Steve



--
Get lost $teve. Go away... far away....
I mean: Go ... go ...go

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html

Arno R