displaying excel sheets in access

[mortgsteps]

I would like to display some excel worksheets in access. Presently i have an unbound object and i manipulate the sourcedoc and sourceitem based on some criteia to display the second and third sheet of a large workbook. This is pretty slow and cumbersonme but it does work. Is there a better way to do this on Access 97 [sig][/sig]

 

[DougP]

DoCmd.TransferSpreadsheet
will work
but I don't think you can specify any other sheets but the first one.

That's always an age old problem when you out grow Excel and need the power of a real database.
[sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]