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