Copying from MS Access

shades · Apr 15th, 2002, 07:46 AM

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 · Apr 15th, 2002, 08:31 AM

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 · Apr 15th, 2002, 10:21 AM

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 · Apr 15th, 2002, 12:21 PM

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 ]

Apr 15th, 2002, 07:46 AM	#1
shades Board Regular Join Date: Mar 2002 Location: Near the Land of Oz Posts: 1,550	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)

Apr 15th, 2002, 10:21 AM	#3
shades Board Regular Join Date: Mar 2002 Location: Near the Land of Oz Posts: 1,550	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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 15th, 2002, 08:31 AM	#2
wi_guy Board Regular Join Date: Mar 2002 Posts: 50	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.

Apr 15th, 2002, 12:21 PM	#4
shades Board Regular Join Date: Mar 2002 Location: Near the Land of Oz Posts: 1,550	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 ]