Tranfer Excel Non-Columnar Data to MS Access

[gmoney]

How would you move non-columnar data from excel to ms access?

I have a spreadsheet which has data not placed in column form.

Would you move the data to another worksheet and organize it in columns and then import into Access?

Or would you just transfer the data to Access setting field values and transferring it through code?

Any info on Excel Data to Access would be helpful non the less.

Thanks.

 

[MichaelRed]

Without knowing (and probably actually having the real worksheet), I can not give any real advice. In a totally generic sense, MS Access is a good environment for analysing stuff and getting data from it (the Stuufffffff). So I would probably just dump the Stuuuuuffffff into a temporary table in Ms. Access and do the wheat / chaff thing over there. Then again, 'without actually seeing the ....... '

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over