Import Data Every Week

[adnancanada]

I have created a database and I have to import excel files on every week. I have to do it manually every time. I want user to browse that file through from Form button and import in my access database as tables. Kindly help me out. I need vba or macro whatever is convient for user.
Thanks.

[CJ_London]

for browsing, google filesystemobject and for importing you can probably use transferspreadsheet

here are some examples

http://www.jpsoftwaretech.com/vba/fi...-vba-examples/

http://access.mvps.org/access/general/gen0008.htm

[adnancanada]

for browsing, google filesystemobject and for importing you can probably use transferspreadsheet

here are some examples

http://www.jpsoftwaretech.com/vba/fi...-vba-examples/

http://access.mvps.org/access/general/gen0008.htm

Thanks Ajax, Thats I was looking for. I have not tried yet but I will do on weekend. Thx.