How to get Cells(i,j) value in Access?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrei - 17 Feb 2006 03:43 GMT

Hi guys,

I got a CSV file with more than 300000 raws so I couldn't open it in
Excel. I decided to use Access but I can't access the data using
standard way such as Workbooks(Name).Cells(i, j).Value as I used to do
in Excel. I really need to do some manipulatons with data and SQL is
not good enough.

Can you please advice me a way to solve this problem.

Thanks a lot,
Andrei

Reply to this Message

Larry Linson - 17 Feb 2006 04:38 GMT

There is no Workbooks Collection, nor Cells collection in Access. Access has
a different object model and is not "a spreadsheet on steroids". If that
(spreadsheet on steroids -- a spreadsheet with essentially unlimited number
of rows) is _really_ what you need, then Access is not the tool you are
looking for.

I can only suggest that, if you give some worthwhile detail about the
information you have, and what you want to accomplish (not how you expect to
do so), perhaps someone can make a suggestion that will be useful to you.

Larry Linson
Microsoft Access MVP

> Hi guys,
>
[quoted text clipped - 8 lines]
> Thanks a lot,
> Andrei

Reply to this Message

Andrei - 17 Feb 2006 04:50 GMT

Thanks a lot Larry for the response,

What I want to do is to transform data from one file which contains
many raws to another which contains many columns.
The example can be that initially I got
Column1 Column2 Column3 Column4
1 A Q1 100
1 B Q1 250
1 C Q1 300
1 A Q2 150
1 B Q2 100
etc

and want to get table like

Column1 Column2 Column3 Q1 Q2
1 A Q1 100 150
1 B Q1 250 100
1 C Q1 300
etc

I had difficulties to find how to do it in Access but the file is too
big to be opened in Excel.
Any advice will be much appreciated.

Andrei

Reply to this Message

Larry Linson - 17 Feb 2006 05:33 GMT

Almost always, when you see column _data_ being converted to column
headings, it is a sign that the data is being DEnormalized -- that is,
violating good relational database design principles. Am I correct that the
example you gave, that is 5 columns, is incomplete, that it may/will have
many more than 5 columns? You certainly can't save much space with a 4:5
ratio!

Again, I suggest you explain what you have and what you are trying to
accomplish, in words, in some detail, and not tell us _HOW_ you had in mind
to accomplish it.

It concerns me when I see someone post an example rather than a description,
that they are "fixated" on a particular approach, whether that approach will
actually work or not. And when they do so, in response to a request for
description, it concerns me even more.

Larry Linson
Microsoft Access MVP

> Thanks a lot Larry for the response,
>
[quoted text clipped - 22 lines]
>
> Andrei

Reply to this Message