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