Unable to import data using DSN file from SQL Server to Microsoft Excel or Access?

5 pts.
Tags:
Database connectivity
DSN connection
Microsoft Access
Microsoft Excel
SQL Server connectivity
SQL Server import/export
hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver... i believe every thing should be fine. I have check the access permission for that user. that is not the issue. when i was helpin to that person what i see, he import using dsn file.... it takes a while it just bring header name( column name) but there is no data, i tried using excess database and excel both same issue no error message just return header information. if i use same dsn file it work for me and also for other people as well only few people is having this issue. i am kind of blind can't tell where the problem is. is that issue from clinat's machine, security ? help me figuer out the issue.. please

Answer Wiki

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

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
  • Sagar2000
    [...] server to excel or … Commercial Law book: Integral Logistics Management or Operations … Daily Dose of Excel » Blog Archive » Euler Problem 79Do You Use Calcium - Orchid Board - Most Complete Orchid Forum on … hotels: The Hotelling [...]
    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