If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Reserved Error (|); while importing data to Excel from MS Access
|
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|