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

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

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

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

"Andrei" <dushenka2002@mail.ru> wrote in message
news:1140147834.315903.167840@g43g2000cwa.googlegr oups.com...[color=blue]
> 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
>[/color]

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

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

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

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






"Andrei" <dushenka2002@mail.ru> wrote in message
news:1140151842.672514.79860@g44g2000cwa.googlegro ups.com...[color=blue]
> 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
>[/color]