Transfer OLE Object data to table

  • Thread starter kennytwk via AccessMonster.com
  • Start date
K

kennytwk via AccessMonster.com

hi,
i have a Microsoft Office Spreadsheet 11.0 in my form, how do i transfer the
data i have key into it to a table that i have created earlier, i will be
only using 3 columns in the OLE object, my table have 3 columns as well.(now
i have a form with the OLE object, a save button to save the OLE object to
the table, a table)

Should i make a connection to the OLE object or just retrive straight from
the object?

Should i retrieve the data cell by cell or using a range "A1:Cn", n= EOF?

can someone point me to a good link on my topic?
thanks

KT
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top