How to import data to access from sql?

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

Accepted Solution

Bill Bach earned 2000 total points
ID: 24194389
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 29

Expert Comment

by:Bill Bach
ID: 24411187
Recommendation: Accept above response

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

850 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