| Home |
| Search |
| Today's Posts |
|
#1
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
Posted to microsoft.public.excel.links
|
|||
|
|||
|
Reserved Error (|); while importing data to Excel from MS Access
|
|
#3
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
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
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing data from Excel to Access | Excel Discussion (Misc queries) | |||
| Error when importing external data from Access | Excel Discussion (Misc queries) | |||
| Renaming Worksheet: Error message: "Reserved Name" | Excel Discussion (Misc queries) | |||
| Importing Data from Access into Excel | Excel Discussion (Misc queries) | |||
| Importing data from Access into Excel: prob w/ cutting off fields | Excel Worksheet Functions | |||
Linear Mode
