Export Excel to Access Table??

Hi,
i'm using DAO data object.
Anyone knows how to Export Excel to Access Table??

Please help.. Thanks.

Thomas

hmm... I've just been asking about this. Apparently for DAO it's simply this

dim db as database
on error resume next

set db = workspaces(0).opendatabase(app.path & "worksheet.xls")

db.execute "SELECT * INTO [c:\temp\mydb\ from [mytablename]

Hope this helps, this code hasn't worked for me yet, but I tested the sample files given to me from http://www.smithvoice.com
and they work.

See thread:

http://forums.vb-world.net/showthrea...threadid=26697