Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to connect excel(If I consider it as a database) with a websit SATABDI NATH Excel Discussion (Misc queries) 0 July 8th 08 12:34 PM
How to connect to database? Eric Excel Worksheet Functions 3 July 25th 07 12:55 PM
Working with ADO to connect to SQL database veritasca Excel Programming 4 April 26th 04 10:56 PM
Connect to Oracle Database through ODBC with VBA jamiee Excel Programming 1 April 15th 04 03:31 PM
How to connect to Informix database using ADO??? Mlaky[_2_] Excel Programming 2 February 12th 04 08:56 AM


All times are GMT +1. The time now is 11:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"