By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,275 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

VS2005 Importing Microsoft Access Database Into MDF Format

P: n/a
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 ?

--
Goofy
Dec 21 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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%
--

Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006
"Goofy" <me@mine.comwrote in message
news:O5**************@TK2MSFTNGP02.phx.gbl...
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 ?

--
Goofy

Dec 21 '06 #2

P: n/a
I am running express. Where is the import function ?
"Mark Fitzpatrick" <ma******@fitzme.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
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%
--

Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006
"Goofy" <me@mine.comwrote in message
news:O5**************@TK2MSFTNGP02.phx.gbl...
>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 ?

--
Goofy


Dec 21 '06 #3

P: n/a
I'm pretty sure you can do this with the SQL Server Management Studio
Express
http://www.microsoft.com/downloads/d...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" <me@mine.comwrote in message
news:ud**************@TK2MSFTNGP03.phx.gbl...
>I am running express. Where is the import function ?
"Mark Fitzpatrick" <ma******@fitzme.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>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%
--

Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006
"Goofy" <me@mine.comwrote in message
news:O5**************@TK2MSFTNGP02.phx.gbl...
>>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 ?

--
Goofy



Dec 21 '06 #4

P: n/a
TA

"Mark Fitzpatrick" <ma******@fitzme.comwrote in message
news:OY**************@TK2MSFTNGP06.phx.gbl...
I'm pretty sure you can do this with the SQL Server Management Studio
Express
http://www.microsoft.com/downloads/d...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" <me@mine.comwrote in message
news:ud**************@TK2MSFTNGP03.phx.gbl...
>>I am running express. Where is the import function ?
"Mark Fitzpatrick" <ma******@fitzme.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>>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%
--

Hope this helps,
Mark Fitzpatrick
Former Microsoft FrontPage MVP 199?-2006
"Goofy" <me@mine.comwrote in message
news:O5**************@TK2MSFTNGP02.phx.gbl...
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 ?

--
Goofy



Jan 3 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.