datamining SQL with access

0 pts.
Tags:
Access
Data analysis
Data mining/analysis
Desktops
Management
Microsoft Windows
OS
Security
Servers
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
ASKED: January 4, 2007  4:29 PM
UPDATED: July 4, 2008  5:34 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • MODMOD
    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.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following