Using an Access form from within Excel

[nu2xl]

I am very new to this VBA stuff so please bear with me

I am trying to utilise an access dbase to store sata that my excel sheet will be using. The VBA is all being done from excel.

Is there a way to open an access form from excel WITHOUT having the access window open?

If there isn't a way to do that. How do you even get the access application up and running? I have tried...

'From within excel
dim obj as Access.Application
set obj = GetObject("blahblah\mydb.mdb&quot

Now I am lost from even this "simple" procedure.

Any help would be gratefully appreciated

 

[outhere]

I really have to know how to import all my excel documents into an access table as well!!! please by tonight, I cant leave the office until its done !!!

I can import one excel sheet no prob, but when I go to import the next, though it has all the same amount of feilds into that same table I get an error message....

WTF Ive been trying different ways for hours now!!

Desprate beyond belief....
Steve