We have a database that is specifically designed for our industry. We want to be able to export the information into a mailing list. This is the email that I received from IT. "You cannot export to an access database, but you can connect to the KIDS database with Access or with Excel query to extract a merge file for use in mailing. You just have to set up an ODBC connection to the database".
How in the heck do I do this? I did something on the server the other day - I thought making this so called connection. Then if I go into Access and click on File, New and then on the right hand side click on Blank Data Access page, then click on New Source, click next and then enter the Server information - it doesn't show up in the list.
If someone can help me do this I would greatly appreciate it. Completely new territory for me.