matrix in access

[thread]

Hi all,
is there an option to build matrix in access?

 

[Stefan Hoffmann]

hi,

is there an option to build matrix in access?

Yes, but you have no matrix operators.

Each table can be threated as a matrix equivalent. In VBA you can use
multi-dimensional arrays.

btw, what do you like to do?


mfG
--> stefan <--

 

[thread]

the metrix is going is follow:
you have countries as vertical and i have names as horizontal,the
issue is that i want to have an option to load it from excel to access
as is but still to be able to use it in the relations between other
tables
any code samples?

Stefan Hoffmann כתב:

 

[Stefan Hoffmann]

hi,

the metrix is going is follow:
you have countries as vertical and i have names as horizontal,the
issue is that i want to have an option to load it from excel to access
as is but still to be able to use it in the relations between other
tables

This depends on your tables. One entry for each cell, e.g. a table like
ID, Country, Name should do it. It is not easy to import.

Start with

DoCmd.TransferSpreadSheet

to import the data. Then you need to process it in VBA with to loops:

For Each Row In Table
For Each Field In Table
Store Data in real table
Next Field, Row

You can access the field names of your import table with

CurrentDb.TableDefs.Item("importTable").Fields


mfG
--> stefan <--