Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Copying from MS Access

  1. #1
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have run into an unusual (for me) event. If I select a table of data in MS Access 97 and copy it, then go to MS Excel 97 and paste the data, everything works.

    However...

    I use one Excel workbook for a working document, in which I use many macros, repeatedly. After one or macros run, then when I go back into Access, copy a table, and paste into Excel, I get a warning: "File not found!" When I click OK, then another warning appears: "Excel could not paste the document!" Yet, when I click OK, the data all appears in Excel.

    Is there something wrong with Excel? Is there something I can do to get rid of the warnings, since everything seems to work fine and pastes into Excel, even though Excel claims that it couldn't paste?
    - old, slow, and confused
    ... but at least I'm inconsistent -

    (retired Excel 2003 user, 3.28.2008)

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Never experienced that problem, but your may want to consider ODBC linking right to the data table in Access. (Data:Get External Data:Create New Query)...then the data pull is done right from Excel. If it sounds like this may help, let me know your email and I'll send you an MS word document that I created that walks you through the process.

  3. #3
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It sounds like it might be very helpful. I sent you an email separately. If that doesn't work, send it to:

    shades@applelinks.net
    - old, slow, and confused
    ... but at least I'm inconsistent -

    (retired Excel 2003 user, 3.28.2008)

  4. #4
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, wi_guy, it worked great! A real time saver.

    Now, follow-on question. If I saved this spreadsheet on the server where others could have access to this information, would the query still work for someone else? That is, six other people use the data, but don't know anything about Access, so would this be their chance to view the data? (This is apart from my own additional analyses, which they don't need.)

    _________________
    - old, slow, and confused
    ... but at least I'm inconsistent -

    [ This Message was edited by: shades on 2002-04-15 12:41 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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