How to import data to access from sql?

Posted on 2009-04-20
Last Modified: 2013-12-25
I need to import data to Access from SQL. Please provide me the steps to follow.
Question by:harshail
    LVL 28

    Accepted Solution

    From MS Access 2003 or earlier, right-click on the Tables page and select Import.  Under "Files of type", scroll down the drop box and select ODBC Databases().  This will change the dialog box.  Next, select your ODBC data source, and it will import the tables.

    If Access 2007, select External Data on the ribbon, then under Import, select More, and select ODBC, then select the Import radio button.  Then select your ODBC DSN and continue importing.

    LVL 28

    Expert Comment

    by:Bill Bach
    Recommendation: Accept above response

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now