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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!