how to save a matrix (msflexgrid) into a table?

[migueleitor]

hi,

how do i do to save a matrix which it's in a msflexgrid in visual basic to a table in microsoft access?

how should i define the table, and how to save in a table?

here it's a example of the matrix in visual basic, it's shown in a msflexgrid and i want to save in a table

bluetooth hiperlan homerf ieee 802.11
bluetooth 0 0 0 0
hiperlan 0 0 0 0
homerf 0 0 0 0
ieee 802.11 0 0 0 0
att 0 0 0 0.1515
ericsson 0.01643 0.01587 0 0
lg 0.2108 0 0 0
brightcom 0.02555 0 0 0
nokia 0.02236 0 0 0
philips 0.002434 0.08465 0 0.3776
samsung 0.2109 0 0 0.001176
siemens 0.00575 0.02222 0.2 0
texas 0.009584 0 0 0
bizmodeline 0.01597 0 0 0


thank you.

 

[ArtieChoke]

You could create a table with the following fields:

Name (text)
bluetooth (numeric)
hiperlan (numeric)
homerf (numeric)
ieee80211 (numeric)

Then loop thru the grid using the TextArray property (see example in VB help) and populate each row of the table from the flexgrid rows.