VS2005 Importing Microsoft Access Database Into MDF Format

[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 ?

 

[Mark Fitzpatrick]

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%

 

[Goofy]

I am running express. Where is the import function ?

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%

 

[Mark Fitzpatrick]

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

I am running express. Where is the import function ?

 

[Goofy]

TA

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