I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that access will see the database (mssql7 at one property and MSDN at the other I think). Currently the files are .mdf and .ldf files. I understand how to query the table and know whick one I need but right now I am not set up where I can open the database with access. I am obviously doing something wrong.
Thanks in advance
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!