Macro or VBA to Open ODBC Database Wizard

[Liz_I3]

Hi
Is it possible in Access 2010 to create a macro or vba to open the Get External Data ODBC Database wizard? In the same way as if you clicked on the ODBC Database button on the ribbon under External Data

Thanks
L

 

[mole999]

have you tried recording the action and seeing if it is captured

 

[Liz_I3]

I knew you could record a macro in excel but is it possible in Access?

 

[mole999]

ther you have me, I haven't used access for ages

 

[xenou]

What are you actually trying to do? Assuming connect to a database, what kind, for what purpose?
Edit: note, and no, no recording macros in MSAccess.

 

[Liz_I3]

There are 2 tables we have to replace daily they are not linked they are views from a sql server . I wanted a button that would open up the ODBC Wizard.

 

[xenou]

Why do you need to replace a table everyday?

 

[xenou]

I'm asking b/c in general I would try to just do that automatically. Or if that's not possible, using the existing data wizards just like presumably you are already doing. As far as getting the same wizard you have in Excel, probably not going to work.

 

[Liz_I3]

The tables should be a link to just refresh but our IT has set it up to replace tables daily. Iam not trying to get Excels wizard. In Access on the Ribbon under External Data Then in Import and Link there is a Icon/button ODBC Database. I wanted to program my on button to open that ODBC Database icon on the Access Ribbon (when you click it on the ribbon it opens up a wizard). I was thinking SendKey may work but can't find any code to access Ribbon selections

Thanks for you help
Liz

 

[xenou]

You can add button to your QAT for easy access in one click. Personally I'd think it's still possible to try to automate this if you know what the changing information is. Not really sure what's changing (for instance, you can create new tables every day but if they have the same name then Access wouldn't care about it).