Export Excel to Access Table??

[tomtan]

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

Please help.. Thanks.

Thomas

[Paylo]

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.

[JHausmann]

See thread:

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