possible to get and copy data from database to excel?

You should be able to do this with a thing called MS-Query. However you will need to set up an ODBC connection for which you will need the drivers. Chances are if you have the database, you already have the drivers installed. Otherwise, go out to the web and get them.

The trick to using MS-Query is to develop the SQL in some other tool like WinSQL or TOAD. Then turn off the Wizard for MS-Query. When you launch MS-Query and make the connection, close out the windows that show you the tables. MS-Query is a terrible tool to develop anything other than the simplest of queries. Instead click on the SQL icon and paste the SQL code in there.

MS-Query will remember your credentials if you tell it to. However, they are stored in plain text in the connection string. If this is OK for your environment, so be it. There is a VBA workaround using hidden code and / or hidden sheets that can supply the credentials, run the query and then remove them if you are in a more "hostile" environment, but, well, it's Excel security. Otherwise you will be prompted to enter your credentials when you run the query.

Generally speaking you won't need any VBA with MS-Query. If the query can be displayed graphically, then you can even pass parameters to it at run time. If it cannot be displayed graphically or it's dynamic (like a model list that changes frequently), then there is some very simple VBA you can use to rewrite the SQL before running it. Basically you enter the SQL in an Excel table, make substitutions in the table, and the VBA takes it from there.

If you want to give this a try, give me a shout. Here is some more information on MS-Query: http://www.utteraccess.com/wiki/MS_Query.