(Msg. 1) Posted: Wed May 21, 2008 1:11 am
Post subject: Reserved Error (|); while importing data to Excel from MS Access Archived from groups: microsoft>public>excel>links (more info?)
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.
(Msg. 2) Posted: Thu Jun 05, 2008 5:09 pm
Post subject: Re: Reserved Error (|); while importing data to Excel from MS Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
rishi.sahoo.DeleteThis@gmail.com schrieb:
> 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.
I have the same problem, would be nice if somebody can help !!!
(Msg. 3) Posted: Fri Jun 06, 2008 7:47 am
Post subject: Re: Reserved Error (|); while importing data to Excel from MS Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 4) Posted: Tue Jun 24, 2008 8:00 am
Post subject: Re: Reserved Error (|); while importing data to Excel from MS Acce [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"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.
(Msg. 5) Posted: Thu Jun 26, 2008 12:40 am
Post subject: Re: Reserved Error (|); while importing data to Excel from MS Acce [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 6) Posted: Thu Jun 26, 2008 7:07 am
Post subject: Re: Reserved Error (|); while importing data to Excel from MS Acce [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
>
>
(Msg. 7) Posted: Thu Jun 26, 2008 11:41 pm
Post subject: Re: Reserved Error (|); while importing data to Excel from MS Acce [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 8) Posted: Mon Jun 30, 2008 8:34 am
Post subject: Re: Reserved Error (|); while importing data to Excel from MS Acce [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office