Export query to Excel fails
in [General]
|
From: JR Hester on 19 Apr 2010 17:50 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.
From: Daryl S on 20 Apr 2010 09:34 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. > >
From: JR Hester on 20 Apr 2010 11:12 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. > > > >
From: Daryl S on 20 Apr 2010 12:19 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. > > > > > >
From: JR Hester on 21 Apr 2010 11:04 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. > > > > > > > >
|
Next
|
Last
Pages: 1 2 Prev: running access 2007 in batch file Next: Can Anyone help me with a Technology Lending Library? |