Reserved Error (|); while importing data to Excel from MS Access
While importing data to Excel using a query in MS Access using MS
Query, I get and error message saying "Reserved Error (|); ". Can anybody help me in solving this issue. |
Reserved Error (|); while importing data to Excel from MS Access
|
Reserved Error (|); while importing data to Excel from MS Access
Lilo Meier wrote:
Reserved Error (|) Are you perhaps running a query on tables in Access which are linked to tables in a different type of database? If so, what is database that contains the data? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reserved Error (|); while importing data to Excel from MS Acce
"Bill Manville" wrote:
Are you perhaps running a query on tables in Access which are linked to tables in a different type of database? If so, what is database that contains the data? Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup I am having the same error, and as you asked I am trying to export a query which is querying a view that is linked from a Sql Server 2000 database. It has a date parameter which is used to select the correct records. The query itself runs fine, but I can not export it from access to excel. Is there an issue with the linked table? |
Reserved Error (|); while importing data to Excel from MS Acce
Mendicant wrote:
Is there an issue with the linked table? I guess so. Is there a reason why you can't query the SQL Server 2000 database directly from Excel? I would think you should be able to, by setting up an appropriate ODBC connection. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reserved Error (|); while importing data to Excel from MS Acce
That's the odd thing. I can query it fine. I've built a query off of the
linked view and can select records in only the month that I require, but as soon as I try to export the information in the query to excel, I get the error. "Bill Manville" wrote: Mendicant wrote: Is there an issue with the linked table? I guess so. Is there a reason why you can't query the SQL Server 2000 database directly from Excel? I would think you should be able to, by setting up an appropriate ODBC connection. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reserved Error (|); while importing data to Excel from MS Acce
As I said, Is there a reason why you can't query the SQL Server 2000 database directly from Excel? I would think you should be able to, by setting up an appropriate ODBC connection. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reserved Error (|); while importing data to Excel from MS Acce
Sorry, I misunderstood. That makes sense to do the query straight from excel.
Thanks! "Bill Manville" wrote: As I said, Is there a reason why you can't query the SQL Server 2000 database directly from Excel? I would think you should be able to, by setting up an appropriate ODBC connection. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
All times are GMT +1. The time now is 12:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com