+ Reply to Thread
Results 1 to 2 of 2

Copy and Paste Error From Access to Excel

  1. #1
    Registered User
    Join Date
    03-29-2013
    Location
    New York, USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Angry Copy and Paste Error From Access to Excel

    Hi All,

    I never had any problem with this until today, while I was trying to copy a set of data from an Access table onto an Excel spreadsheet, data and columns are misaligned. For example, I have a table with 12 headers (columns) and 100 rows. When I copy the data from Access, then pasted it onto an Excel spreadsheet, data itself seems corrupted and misaligned. One thing I noticed is if there is a number with 2 decimals, e.g. 138.52, it will appear as two numbers on Excel. (see picture below)
    untitled.JPG

    Does anybody have this problem?? Any help is appreciated.

  2. #2
    Forum Contributor
    Join Date
    03-12-2013
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2007
    Posts
    230

    Re: Copy and Paste Error From Access to Excel

    I'm not very familiar with this problem, but whenever I need to get data from Access into Excel, I just export it. Have you tried exporting it?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1