I am somewhat of a n00b when it comes to database programming, so bear with me. Since you are adding an Access connection, select “Microsoft Access” and click “Next. Then execute a query to export your data and then detach the MDF. Please Sign up or sign in to vote. Click “Finish” to create the connection and save it to your computer. Hey, nice to hear that you was successfull. Ask and answer questions to get Brothersoft credits.

Uploader: Kik
Date Added: 8 March 2006
File Size: 50.78 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 54379
Price: Free* [*Free Regsitration Required]

I am afraid these files alone are useless on a Linux machine. Treat my content as plain text, not as HTML. Provide an answer or move on to the next question.

Take note of table names, fields, queries, views, stored procedures, and relationships between th Click the “System and Security” link in the new window. Restore MDF file to Sql server. Chances are they have and don’t get it. Try to automate that.


I’d upvote but I lack the necessary reputation points. The defaults to open the Access file are applied.

I do most of my data analysis with Perl scripts. Let’s work to help developers, not make them feel stupid.

Sign up using Email and Password.

Stack Overflow works ofbc with JavaScript enabled. Existing Members Sign in to your account. Could anyone attempt to point me in the right direction?

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. I am somewhat of a n00b when it comes to database programming, so bear with me. Am I missing something totally obvious? Please Sign up or sign in to vote.

When answering a mdff please: If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem.

Can I use it as an odbc database?

mdf file as odbc database , odbc driver for mdf files in xp

Sharing mdf file on a network. Ask a question now. Click the Windows “Start”‘ button and select “Control Panel” from the menu options. Any help would be greatly appreciated!


Are you sure to delete your answer? Solve software problem quickly Share experience to help others Improve the ability of solving problem.

Click the MDB file you want to use in the connection. Hey, nice to hear that you was successfull. Read the question carefully.

How to Add an MDF Into an ODBC – Microsoft Access Q&A

Don’t tell someone to read the manual. In Excel, open up a new document and begin with “Row 1” and “Column A. I’ve tried remedying this a number of ways over the past couple days, and I won’t post them here for the sake of brevity.