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.

 

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.

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

 

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

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

Password Recovery ASA 5520

Password Recovery Process for Cisco ASA 5520.

1. Reboot Power
2. When prompted , press Esc to interrupt the boot process and enter ROM monitor mode.You should see a Rommon Prompt (rommon#0> ).
3. rommon#0>confreg (press enter).
4. current configure register should be default of 0x01. Device will ask if you want to make changes to the configuration register.
   Answer : NO
5. You must change the configuration Register to 0x41.
6. rommon#1>confreg 0x41
7. Reset the device.
8. rommon#2> boot
9. Now after booting you will see a general user mode like. ciscoasa>
10. ciscoasa> enable password
11. ciscoasa#
12. ciscoasa#copy startup-config running-config
13. ciscoasa#config t
14. ciscoasa(config)#enable password
15. Reset the configuration to default value 0x01.
16. ciscoasa(config)#config-register 0x01
17. View the configuration register setup
18. ciscoasa#show run startup-config
19. reload
20. ciscoasa#reload
21. System config has been modified,save [Yes][No]
22. press Yes.