VS2005 Importing Microsoft Access Database Into MDF Format

  • Thread starter Thread starter Goofy
  • Start date Start date
G

Goofy

The add database ( MDF ) in Visual Studio 2005 seems to be in SQL Server
2005 format as far as I can tell. Does anyone know how I can import tables
( without having to start writing queries ) from Access ?
 
Best thing you could try is running SQL Server 2005 Express edition. Then
you could connect to the MDF file, and use the Import | Data function to
import in the Access data. I works pretty good though you'll want to tweak
things afterwards as the datatypes don'tnecessarily match 100%
 
I am running express. Where is the import function ?


Mark Fitzpatrick said:
Best thing you could try is running SQL Server 2005 Express edition. Then
you could connect to the MDF file, and use the Import | Data function to
import in the Access data. I works pretty good though you'll want to tweak
things afterwards as the datatypes don'tnecessarily match 100%
Click to expand...
 
I'm pretty sure you can do this with the SQL Server Management Studio
Express
http://www.microsoft.com/downloads/...AE-4BD1-4E3D-94B8-5A0F62BF7796&DisplayLang=en

You should be able to select the database, selct tasks, and import data. I
haven't played with this in a long time and I'm realizing I may be mistaken
as this is in the full sql server management studio, but I can't remember
exactly if it's there.

The other way is to create an odbc connection to the sql server express that
you can use in Access then in access you can export the data to the odbc
connection.


--

Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006



Goofy said:
I am running express. Where is the import function ?
Click to expand...
 
TA

Mark Fitzpatrick said:
I'm pretty sure you can do this with the SQL Server Management Studio
Express
http://www.microsoft.com/downloads/...AE-4BD1-4E3D-94B8-5A0F62BF7796&DisplayLang=en

You should be able to select the database, selct tasks, and import data. I
haven't played with this in a long time and I'm realizing I may be
mistaken as this is in the full sql server management studio, but I can't
remember exactly if it's there.

The other way is to create an odbc connection to the sql server express
that you can use in Access then in access you can export the data to the
odbc connection.


--

Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006
Click to expand...
 
Back
Top