5 pts.
 Unable to import data using DSN file from SQL Server to Microsoft Excel or Access?
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

Software/Hardware used:
ASKED: February 15, 2009  7:09 PM
UPDATED: February 16, 2009  2:16 PM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _