Recrod a macro? in MS Access?

[Guest]

Hi all,

Is it possible to “record a macro†in access like you can in Excel? I cant
seem to find a similar function

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†saves table with
the same name, then execute query “xxxx†then query “xxxx†then Export file
to c:/data/xxx.xx

Can anyone point me in the right direction for some info? Thanks in advance!

Ernest

 

[Steve Schapel]

Ernest,

No, there is no provision to "record" a macro in this way. You need to
write the macro in the macro design window. From your description, it
sounds like for a start you would need these actions in your macro:
TransferSpreadsheet
OpenQuery
OpenQuery
TransferText

 

[Guest]

worked a treat thanks very much

Ernest,

No, there is no provision to "record" a macro in this way. You need to
write the macro in the macro design window. From your description, it
sounds like for a start you would need these actions in your macro:
TransferSpreadsheet
OpenQuery
OpenQuery
TransferText