Prev: running access 2007 in batch file
Next: Can Anyone help me with a Technology Lending Library?
From: Daryl S on 22 Apr 2010 09:57
JR -

Sorry, I am on Access 2003. I do lots of exports, but if this is specific
to A2007, then you may want to repost and see if someone else can help...

--
Daryl S


"JR Hester" wrote:

> Daryl,
>
> Thanks for the instruction, I believe as memry serves that will work well
> for Access 2002 and earlier. However, in Access 2007, the is no FIle> Export
> option-- Export is a group in the External Data tab. That is the process I am
> using. the problem is that on this particular query, I keep getting the error
> posted in my original post.
>
> Thanks for your response,
>
> "Daryl S" wrote:
>
> > JR -
> >
> > To do it manually when the query is open, choose File | Export...
> > Then in the dialog box select the Excel file type you want from the bottom
> > "Save as type" drop-list, navigate where you want and give it a name.
> >
> > --
> > Daryl S
> >
> >
> > "JR Hester" wrote:
> >
> > > Daryl,
> > >
> > > Thanks for the response, I should have been more specific. This is a manual
> > > process, I simply open the query, then chose the Excel button on teh External
> > > data tab. It worked at least once, because I have an excel spreadsheet from
> > > two weeks ago. I can successfully use this process on other queries, just not
> > > this one any longer.
> > >
> > > Here is the SQL code for the query:
> > >
> > > SELECT tblParticipantTrx.EmpID, tblSessions.StrtDate, tblSessions.StartTime,
> > > tblClasses.ClassName, tblParticipants.EmpFname, tblParticipants.EmpLname
> > > FROM (tblClasses INNER JOIN tblSessions ON tblClasses.ClassID =
> > > tblSessions.ClassID) INNER JOIN (tblParticipants INNER JOIN tblParticipantTrx
> > > ON tblParticipants.EmpID = tblParticipantTrx.EmpID) ON tblSessions.SessionID
> > > = tblParticipantTrx.SessionID
> > > WHERE (((tblSessions.StrtDate) Between [Begin] And [end]))
> > > ORDER BY tblSessions.StrtDate;
> > >
> > > Thank you,
> > >
> > >
> > >
> > > "Daryl S" wrote:
> > >
> > > > JR -
> > > >
> > > > How are you doing the export (macro, manually, code)? Post your code /
> > > > macro so we can see.
> > > >
> > > > --
> > > > Daryl S
> > > >
> > > >
> > > > "JR Hester" wrote:
> > > >
> > > > > Access 2007 on WinXP
> > > > >
> > > > > When export query results to Excel, receive following error:
> > > > > " The specification XMl failed to vailidate againset teh schema. There is an
> > > > > error in the following line of teh XML document: A semi colon character wwas
> > > > > expected.
> > > > > '
> > > > > "
> > > > > This error is confusing as I am exporting to Excel not to an XML file. The
> > > > > actual export to XML appears to complete, but I need teh XLS or XLSX file. A
> > > > >
> > > > > Any suggestions as to how to get the query results into an Excel file?
> > > > >
> > > > > Thank you.
> > > > >
> > > > >
First  |  Prev  | 
Pages: 1 2
Prev: running access 2007 in batch file
Next: Can Anyone help me with a Technology Lending Library?