Importing Microsoft Access into VS2005 MDF File

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

 

[Paul Clement]

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

 

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

 

[Goofy]

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

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.
---------------------------------------