Copying from MS Access

[shades]

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?

 

[wi_guy]

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.

 

[shades]

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

 

[shades]

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