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 ?

--
Goofy
--
Goofy

Dec 21 '06 #1

Subscribe Post Reply

2012

Paul Clement

On Thu, 21 Dec 2006 13:13:33 -0000, "Goofy" <me@mine.comwrote:

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

Dec 21 '06 #2

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" <me@mine.comwrote in message
news:uZ**************@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

Dec 22 '06 #3

Goofy

Thanks to both. I used SQL Server Manager Studio in the end to conver.
"RobinS" <Ro****@NoSpam.yah.nonewrote in message
news:Zq******************************@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" <me@mine.comwrote in message
news:uZ**************@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

Jan 3 '07 #4

Similar topics

Importing a file into Access...

by: Grim Reaper | last post by:

I am importing a .csv file into Access that has 37 fields. My problem is that sometimes the last field only has data at the end of the column (it looks like when you import a file into Access, for...

Microsoft Access / VBA

Question on Importing text data to Access

by: D Mat | last post by:

Hi, I'm trying to get MS Access 2000 to automatically import a series of (~200) flat text, tab delimited, data files into a single Access table, with consistent fields and rows. The files have...

Microsoft Access / VBA

importing an RTF comma delimited file

by: sparks | last post by:

I have never done this and wanted to ask people who have what is the best way. One person said import it to excel, then import it into access table. but since this will be done a lot, I am...

Microsoft Access / VBA

Importing Hidden files

by: dixie | last post by:

If I sent a user an empty database container - dB with no tables and I needed them to import their tables into it and one of their tables was a hidden table with the prefix Usys, is there any way...

Microsoft Access / VBA

Importing .csv file into a datatable VB.NET

by: Jonathan | last post by:

How do you tell the .csv file that you are to import that it has no row headers as I went to the web site http://www.connectionstrings.com/ and under text file it says: "HDR=Yes;" indicates that...

Visual Basic .NET

Importing 4 separate records from one line of an import file

by: kaisersose1995 | last post by:

Hi, I've got an import procedure working, using a standard import specification to import a .csv file into a temporary table. The problem i'm having is that i have 4 different sets of borrower...

Microsoft Access / VBA

VS2005 Importing Microsoft Access Database Into MDF Format

by: Goofy | last post by:

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

ASP.NET

Importing a text file to Access

by: Phil | last post by:

I want to add a button to a form to import a text delimited file. The File is delimited by "^" and so I have created a specification file by manually impoting the text file, using the advanced...

Microsoft Access / VBA

Newbie. How to loop through importing text files and compactingquestions

by: aconti74 | last post by:

Hello I am new to vba programming/coding. I am writing a program that goes through a directory of text files and imports them into the database. The problem is eventually the database gets to big...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice