Importing Microsoft Access into VS2005 MDF File

21 Dec 2006 1:13 PM

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 ?

--
Goofy

--
Goofy

21 Dec 2006 4:45 PM

Paul Clement

On Thu, 21 Dec 2006 13:13:33 -0000, "Goofy" <m*@mine.com> wrote:

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

If I understand your question you're attempting to import Access tables into SQL Server?

One method would be to use DTS (Data Transformation Services) in Enterprise Manager.

You could also try using the Upsizing Wizard in Microsoft Access (Tools...Database Utilities).

Paul
~~~~
Microsoft MVP (Visual Basic)

22 Dec 2006 6:16 AM

RobinS

Are you talking about when you're adding a new data source?
If so, don't choose the option for SQL Server database file;
choose the option for an Access database.

Robin S.
---------------------------------------
Show quoteHide quote

"Goofy" <m*@mine.com> wrote in message
news:uZbqXHQJHHA.1044@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
>
>
> --
> Goofy
>

3 Jan 2007 9:24 AM

Goofy

Thanks to both. I used SQL Server Manager Studio in the end to conver.

Show quoteHide quote

"RobinS" <RobinS@NoSpam.yah.none> wrote in message
news:ZqKdnSpGgrva5RbYnZ2dnUVZ_h-3nZ2d@comcast.com...
> Are you talking about when you're adding a new data source?
> If so, don't choose the option for SQL Server database file;
> choose the option for an Access database.
>
> Robin S.
> ---------------------------------------
> "Goofy" <m*@mine.com> wrote in message
> news:uZbqXHQJHHA.1044@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
>>
>>
>> --
>> Goofy
>>
>
>