Share via

System Data Source can't be accessed in Excel

Anonymous
2011-01-02T05:45:35+00:00

I have a new PC with Windows 7 64 and Office 2010. I've created the same System DSN on the new PC as exists on the old XP machine and the connection verifies OK.

In Office 2010 Excel, going into Data, From Other Sources, From Microsft Query under the Databases Tab does not show the System DSN previously created. Works fine on the old XP / Office 2007 / Office 2003 environment.

Is there something that needs to be enabled to allow Excel to use System Data Sources?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-11-29T08:31:32+00:00

    I assume that you use regular 32 bit Excel, which cannot access system dsn using 64 bit ODBC driver. Since you are using Windows 7 64 bit then the default ODBC configuration is 64 bit, not 32 bit. You have to create new system dsn using 32 bit ODBC driver. This is how you do it: run C:\Windows\SysWOW64\odbcad32.exe and then create new system DSN there.Good luck.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments