Data sources: importing more than 1 table
Under the data tab in Excel, there is an option to "get external data".
When I do this using Access or 'from other sources" using ODBC with Oracle, when I access the DB, I cannot select more than 1 table to import.
Does anyone know how to select and import more than 1 table to import into Excel?
Solutions to the Problem Data sources: importing more than 1 table
Choose Data, From Other Sources, From Microsoft Query.
You can specify multiple tables provided they are related or can be related. If you need help, get back to us and I can give you step by step throught MS Query.
If this answer solves your problem, please check Mark as Answered.
If this answer helps, please click the Vote as Helpful button.
Cheers, Shane Devenshire
Windows Error Reporting - To Fix Data sources: importing more than 1 table
- Go to Start button.
- Open Control Panel.
- Go to Windows Error Reporting.
- Click on System and Maintenance, then click Problem Reports and Solutions.
- Next, click Change Settings located on the left side panel of the Problem Reports and Solutions window.
- Select an option to configure how you want Windows to look for a solution to your problems. You may allow Windows to do it automatically or ask you every time to check if problem occurs.
- Next, click the Advanced settings link.
- Select Off to turn off Error Reporting.
Recommended Method to Fix the Problem: Data sources: importing more than 1 table:
How to Fix Data sources: importing more than 1 table with SmartPCFixer?
1. You can Download Error Fixer here. Install it on your computer. When you open SmartPCFixer, it will perform a scan.
2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.
3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.
Related: How to Update & Download NVidia GeForce 6100/nForce 420 WHQL Certified driver v.178.13,How to Update & Download NVidia GeForce 7600 GS Video Driver v.295.75 Certified,How Can I Update & Download NVidia GeForce 820M Driver v.344.48 WHQL,[Solved] Download NVidia GeForce GTX 560M VGA Driver v.296.17 Certified,Way to Update & Herunterladen NVidia GeForce GT 130M Video Treiber v.295.75 Certified,How to Update & Download SONY SVE14A1X1RH Realtek Ethernet Driver,Where to Download SONY SVS13A2W9ES Bluetooth Driver (Intel) v.2.6 - 18.104.22.168059,Best Way to Update & Download SONY VGN-CR203E Conexant HDAUDIO SoftV92 Data Fax Modem with SmartCP Setup Program v.22.214.171.124 driver,Best Way to Download SONY VGN-FE790G/N Wireless LAN Driver v.10.6.0.29,Method to Update & Download SONY VGN-NR31Z/S Firmware Extension Parser Device v.126.96.36.199,How to Fix Error 0x0000c1f5 Solución?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error
Read More: Troubleshoot:desk top icons stopped responding also task bar icons,Deleting Favorites from IE 8,How to Fix Problem - delete row with condition in another cells?,Troubleshoot:dell desktop Windows 7 Professional 32 bit - after the login screen then the mouse and the keyboard not working Error,Troubleshooting:dep shuts down Internet Explorer 8 when i try to print Error