Home > IT Answers > DataManagement > datamining SQL with access
Help

Question

  Asked: Jan 4 2007   4:29 PM GMT
  Asked by: daiishi

datamining SQL with access


Data analysis, Data mining/analysis, Microsoft Windows, OS, Servers, Security, Desktops, Management, Access, SQL Server

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

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Jul 4 2008  5:34 PM GMT  by Psf


Latest Contributors: AetherKnight


I have a similar problem except that I want to datamine SQL with Analysis Manager Version: 8.00.194. The two sample cubes I have built fail to browse the Foodmart 2000.mdb sample data. The error message is "unspecified error". Access is not installed. As I am asking this question, it is occurring to me that may be I should make a test cube by connection to a couple of my sql tables. If that does not work, I will be back with an update. Thanks in advance for any thoughts. Peter
  • AddThis Social Bookmark Button

Browse more Questions and Answers on DataManagement, Microsoft Windows and DataCenter.

Looking for relevant DataManagement Whitepapers? Visit the SearchDataManagement.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

MODMOD  |   Jan 5 2007  7:48AM GMT

One additional thing to keep in mind. Access seems like it can be a bit overzealous with it’s locking, so you’ll want to make sure your queries run time stays low. I’ve seen an employee with access, and a long running query hang up important jobs more then once.