Using Access

[HomeStar]

I have my Excel spreadsheet that will contain my daily data. I need to
export this to Access on a daily basis. I would like to do this
automatically if possible.

Can I open up Access using VBA and run a macro?

Thank you

 

[Tom Ogilvy]

See MR. Erlandsen's site:

http://www.erlandsendata.no/english/vba/adodao/

If you still think you must open Access:
http://www.erlandsendata.no/english/vba/ole/olebasics.php

 

[HomeStar]

Tom,

The links are broken.

See MR. Erlandsen's site:

http://www.erlandsendata.no/english/vba/adodao/

If you still think you must open Access:
http://www.erlandsendata.no/english/vba/ole/olebasics.php

 

[Tom Ogilvy]

http://www.erlandsendata.no/english/index.php?t=envbadac

http://www.erlandsendata.no/english/index.php?t=envbaole