| Re: migration oracle to access [message #99392] | 
			Tue, 16 October 2001 03:14  | 
		 
		
			
				
				
				
					
						
						Abdullah Gilani
						 Messages: 18 Registered: October 2001 
						
					 | 
					Junior Member  | 
					 | 
		 
		 
	 | 
 
	
		hi, 
you may use Access Import utility, 
Improt from Oracle to Access....... 
open a blanck database in Access 
Righ Click .....now Click on Import.....now Select Files of Types.....select ODBC Databases....add driver for Target Database.....connect Target Oracle Database 
OR 
Click on File .......Click on Get External Data....click on Import.......now Select Files of Types.....select ODBC Databases....add driver for Target Database.....connect Target Oracle Database... 
 
Now you Impot Selected Tables from Oracle Database 
 
Thanks, 
Abdullah Gilani. 
Oracle DBA 
Email: syedgilani@hotmail.com 
 
----------------------------------------------------------------------
		
		
		
 |  
	| 
		
	 | 
 
 
 |