MS Query ODBC login

pixeld00d

New Member
Joined
Aug 28, 2009
Messages
25
Hi... I have an Excel 2003 workbook that pulls data in from an ODBC source using an MS Query via "import external data". Despite checking the option to save the login information, I am still prompted to enter login credentials the 1st time I run the workbook each session. Anyone know a way to embed the login credentials or a vba routine to automate the login?
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi

Doing it via code should be fairly simple. Can you:

Create a new workbook and record a macro of you importing this data from your ODBC source (via MS Query) and then paste the generated code into your reply.

Please state any parameter information you supply (eg if you supply a date to the import so that only records generated up to the date are pulled back or such like).
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,449
Messages
5,837,320
Members
430,494
Latest member
abhi_is_yours

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top