ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   cannot connect to .mdf database (https://www.excelbanter.com/excel-programming/340828-cannot-connect-mdf-database.html)

midavis

cannot connect to .mdf database
 

I've installed the Microsoft Query program to try to use excel to attac
and Query an external .mdf database.

I'm using Data:Import External Data:New Database Query.....
Then I can't seem to find an option for *.mdf files?

I've learned that it is a Microsoft Query "Master Database File"

Thanks for any help accessing this database

--
midavi
-----------------------------------------------------------------------
midavis's Profile: http://www.excelforum.com/member.php...fo&userid=2747
View this thread: http://www.excelforum.com/showthread.php?threadid=46985


NickHK

cannot connect to .mdf database
 
midavis,
According to http://filext.com/detaillist.php?ext...df&goButton=Go,
..mdf files are "SQL Server Master Database File".
I guess if you do not have SQL server or the drivers installed, you would
not see that option.

NickHK

"midavis" wrote in
message ...

I've installed the Microsoft Query program to try to use excel to attach
and Query an external .mdf database.

I'm using Data:Import External Data:New Database Query.....
Then I can't seem to find an option for *.mdf files?

I've learned that it is a Microsoft Query "Master Database File"

Thanks for any help accessing this database.


--
midavis
------------------------------------------------------------------------
midavis's Profile:

http://www.excelforum.com/member.php...o&userid=27475
View this thread: http://www.excelforum.com/showthread...hreadid=469855





All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com