Macros in Access

[Noto]

Hi all,

Is it possible to “record a macro” in MS Access like you can in Excel?

Basically I want to create a macro that will be used on a daily basis. It would import a specific sheet from a specific excel file. And just do the same settings each time like “first row contains headers” then execute query “xxxx” then query “xxxx” then Export file to c:/data/xxx

Can anyone point me in the right direction for some information?

Thanks in advance


Ps. If you read my last post about macros in Excel, I got that to work, this is now a different thing

[edit] ok i have read that you cannot record a macro in access instead you use a macro builder...... anyone have any kinda help / tips sites that might have a pool of info i can read. thanks

 

[Noto]

i've looked at the macro builder :S there doesnt seem to be too many options under action... definatley no import data :S i guess my best bet is to create some kind of VB thing?

 

[OspreyO]

What your looking for is Access VBA

http://www.functionx.com/vbaccess/index.htm