|
| 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
May 21st, 2008, 09:11 AM
posted to microsoft.public.excel.links
|
|||
|
|||
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
June 5th, 2008, 04:09 PM
posted to microsoft.public.excel.links
|
|||
|
|||
|
Reserved Error (|); while importing data to Excel from MS Access
|
|
#3
June 6th, 2008, 08:47 AM
posted to microsoft.public.excel.links
|
|||
|
|||
|
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
June 24th, 2008, 04:00 PM
posted to microsoft.public.excel.links
|
|||
|
|||
|
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
June 26th, 2008, 01:40 AM
posted to microsoft.public.excel.links
|
|||
|
|||
|
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
June 26th, 2008, 03:07 PM
posted to microsoft.public.excel.links
|
|||
|
|||
|
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
June 27th, 2008, 12:41 AM
posted to microsoft.public.excel.links
|
|||
|
|||
|
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
June 30th, 2008, 04:34 PM
posted to microsoft.public.excel.links
|
|||
|
|||
|
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 | |
|
|
Linear Mode
