Skip to main content

How to Import Data (tables) from Postgresql to MS Access Database using ODBC : Step by Step Tutorial

 Import Data (tables) from Postgresql to MS Access Database using ODBC : Step by Step Tutorial for data migration from one Database System to Another Database System.

Objective :- Transfer data tables form PostgresSQL database to MS Access Database.

Step1:- Create a Blank MS Access Database in your Windows system.

Step2:- Open that newly created Access database and go  the External Data tab. Next Click on the More button. Where you will find lots of options. Select the ODBC_databse form that list.

 

Import to ODBC Database

Step 2: Select the source and destination of data. Select the option "Import the Source Data into a new table in the current database", and click OK.


Step 2 : import the source data

Step3: A new Popup window will appear on the screen. Click on the "Machine Data Source" tab. Here you will see the all DNS , data source names . We will select for example "BE" data source name and click OK.


Step 3 , Select Data Source Name


Step 4: Import Objects. In this step you will find all the tables under the BE database. Click on the SELECT ALL button to select all the tables then Press the OK.

 

Import Object Tables

 Step5: Get External Data- ODBC database.All objects are imported successfully. Press the button SAVE IMPORT.

Get External ODBC Data

Step 7: Your data has been successfully imported form the PostgreSQL database server to your local Windows PC's Microsoft Access Database. Enjoy !!

Successfully imported database form PostgreSQl to Local Access Database


Labels:

Comments

Post a Comment

Popular posts from this blog

Do's and Don'ts of Structured LAN Cabling Network

 What is Structured Cabling & Why it is used ? "Standard " is to define a method of connecting all types of vendors voice & data equipment, over a cabling system that uses a common media, common connectors and a common topology. This means that a building can be cabled for all its communications needs without the planner or architecture even having to know what type of equipment will be used. There are three main cabling standards. EIA/TIA 568 A ---> American standard and was the first to be published on 1991. ISO/IEC 11801 ---> International Standard. CENELEC EN 50173 ---> European Standard (British version is BSEN 50173) . TERMS: Cable Tie Patch Panel PVC pipe of Casing IO Box RJ45 connectors Cat 5e/6/7 cable Wall mount Box.
Post a Comment
Read more

How to create user DSN with ODBC driver in Windows System for PostgresSQL Database

 How to create user DSN with ODBC driver in Windows System : Step by Step Tutorial Guide : Step 1: Go to Windows start button -->Click Settings --->Click on Control Panel Step 2: In control panel go to the Administrative Tools Step 3: Double Click on the Data Source(ODBC) icon. A small popup screen with lots of tabs will be appear on the screen. Step 4: Click on the User DSN tab. Step 5: Now click on the ADD button. Now you can see lots of ODBC drivers in the List. Select the appropriate Driver form the List, for example here we chose the PostgresSQL ODBC driver. Step 6: Click on the Finish button. Step 7: Now give the data source name in the appropriate box. Similarly give the database name, ip address of the database server (may be localhost or other private IP address ),then Give the User Name and Password of the database in the appropriate box. Step 8: Press the TEST button to check the connection, whether you put all the parameters correctly or not. If everything is OK t...
Post a Comment
Read more

Password Recovery ASA 5520

Password Recovery Process for Cisco ASA 5520. Reboot Power When prompted , press Esc to interrupt the boot process and enter ROM monitor mode.You should see a Rommon Prompt (rommon#0> ). rommon#0>confreg (press enter). current configure register should be default of 0x01. Device will ask if you want to make changes to the configuration register. Answer : NO You must change the configuration Register to 0x41. rommon#1>confreg 0x41 Reset the device. rommon#2> boot Now after booting you will see a general user mode like. ciscoasa> ciscoasa> enable password ciscoasa# ciscoasa#copy startup-config running-config ciscoasa#config t ciscoasa(config)#enable password Reset the configuration to default value 0x01. ciscoasa(config)#config-register 0x01 View the configuration register setup ciscoasa#show run startup-config reload ciscoasa#reload System config has been modified,save [Yes][No] press Yes.
Post a Comment
Read more