ODBC in Excel Query

How can I have the data refresh not prompt me everytime for my ID and Password?

Can I have it set in the background somewhere?

Thanks
jaymz69Asked:
Who is Participating?
 
redrumkevCommented:
jaymx69,

How are you doing?

See this link:
http://www.pcreview.co.uk/forums/automate-ms-query-odbc-user-name-password-t937610.html

Trying the first option:
Right-click anywhere in the cells where your query data is returned,
and select Data Range Properties from the context menu. Check 'Save
Password' and 'Save Query Definition'.

Or the second option:
Change the properties for the ODBC driver.

Win98: Control Panel>ODBC Sources (32-bit)
Win2K: Control Panel>Administrative Tools>Data Sources (ODBC)
WinXP: Probably similar to Win2K, but I've never done this in XP...

Select the MS Access driver and click Configure. Click on Advanced
and enter the username/password as the default login information.

Hope this helps,
Kevin


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.