OLE Excel field

[dave k]

Sorry for the duplication with the question in Import / Export. After
posting I realized this is the better place to put the quesiton.
_________

I have thought about using an OLE field in Access to store some Excel table
information. It is organized in such a way that standardizing it into fields
is not possible. But here is the problem. I don't see a way of getting that
information out. I can't print it since it will just be snapshot and may not
show the whole field on the page. Plus I can export it to excel.

Am I correct or is there a way to use the data?

Thanks,
Dave

 

[TC]

What is your purpose in wanting to store that data in Access? Why can't
it just stay in the spreadsheet?

TC (MVP Access)
http://tc2.atspace.com

 

[dave k]

I am documenting results of internal control tests. The results of the tests
vary. Sometimes I am testing a sample of 30 invoices, somethimes I am
interviewing someone, sometimes I am testing signoffs on 3 monthly reports.
So I keep the results in an Excel grid. Max rows for results is about 50.
There are several hundred controls and they are tested multiple times per
year. So, it would be much easier than keeping 30 spreadsheets that
reference controls in my db to have the actual results (small grid) in the db.

But, once in an OLE Excel grid I can't print it or export it. So, I am not
sure what the purpose of having this type of field is. I am hoping I am
missing something and can use it.

Thanks!