Copy/paste from Access 2007 into Excel 2007 does not recognize multiple columns of data. All columns are "concatenated" into the first column.
When I copy/paste from Access 2007 data sheet into Excel 2007 worksheet, all source columns of data are "concatenated" into the first target column. Previously (as of 12/22/2010), Excel 2007 recognized each column of data and kept them separate in the target
Has something changed?
How can I get back to proper pasting?
Keys to the Problem Copy/paste from Access 2007 into Excel 2007 does not recognize multiple columns of data. All columns are "concatenated" into the first column.
I have Office 2007 SP2 with the latest updates (from 14 December 2010), Copying from Access to Excel still works correctly.
Does your problem persist after restarting your PC?
Does it occur with all Access databases and all Excel workbooks?
In this method we will try to Boot in Safe mode with Networking and see if the error still persists.
- Search "MSCONFIG" and Open.
- Click on Boot Tab
- Tick Safe Boot in Boot Option
- Select Network.
- Click Apply and OK.
- Reboot your System.
Another Safe way to Repair the Problem: Copy/paste from Access 2007 into Excel 2007 does not recognize multiple columns of data. All columns are "concatenated" into the first column.:
How to Fix Copy/paste from Access 2007 into Excel 2007 does not recognize multiple columns of data. All columns are "concatenated" into the first column. with SmartPCFixer?
1. Click the button to download Error Fixer . Install it on your system. Open it, and it will perform a scan for your computer. The errors will be shown in the scan result.
2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.
3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed
Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.184.108.40.20686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.220.127.116.110,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.18.104.22.1689,Method to Update & Download ASUS K41VD Intel INF Update Driver v.22.214.171.1245,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: [Solved] could you please explain why excel 2007 crashes repeatedly when several users (all using 2007) use a same shared file?,How to Fix - Cumulative Security Update for Internet Explorer 9 in Windows 7 x64 Edition (KB2675157) fails w\/ 8007045D. Any idea why this happens??,Tech Support: current.download host(58 bytes) is preventing windows download manager from displaying.,How to Resolve - Copy time information from one sheet into the master sheet?,How to Fix - could not read whole message from electric bill,no matter how I tried. Do not like OUTLOOK, I did not subscribe to it,why do I have it?,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly