tag:blogger.com,1999:blog-9102955.post898964279847809967..comments2023-02-27T07:01:30.457-08:00Comments on Scott's blog: Access 2007 BugScott Stonehousehttp://www.blogger.com/profile/16932311399052299693noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-9102955.post-52823246079820871162011-11-09T14:56:15.720-08:002011-11-09T14:56:15.720-08:00I had the same issue as the previous post: "I...I had the same issue as the previous post: "I was getting that error message when I used "Export to Excel" on a table...", although it was a regular query, not a make table query.<br /><br />Renaming the query to avoid the "&" symbol seems to have fixed it.<br /><br />Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9102955.post-34600430119583675402011-01-04T11:54:49.537-08:002011-01-04T11:54:49.537-08:00I was getting that error message when I used "...I was getting that error message when I used "Export to Excel" on a table I'd created using a "Make Table" query.<br /><br />My table was called "A & B". When I removed the ampersand (&) from the table name and called it "A and B", I was able to export it. <br /><br />God only knows what posessed me to think of removing the ampersand. I could have been there forever and not figured it out.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9102955.post-35480694736653315942010-09-03T07:22:34.223-07:002010-09-03T07:22:34.223-07:00So... Did this ever get fixed? Anyone ever hear an...So... Did this ever get fixed? Anyone ever hear anything? It's now been three years since this blog was posted, and I just ran into this issue while trying to export a table to Excel (2007)...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9102955.post-57599012993333456442009-07-30T05:31:39.748-07:002009-07-30T05:31:39.748-07:00If you're able to alter the delimiters, I chan...If you're able to alter the delimiters, I changed mine from Concordance delimiters to pipes (|) and carots (^). The import worked perfectly.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9102955.post-90627979906283251052009-04-02T08:57:00.000-07:002009-04-02T08:57:00.000-07:00So happy to see I'm not the only one! If you creat...So happy to see I'm not the only one! If you create a macro with the import spec in an older version it will work in the newer version via the compatibility mode. For now it'll be cvdate for me. WTG Microsoft!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9102955.post-72914573094472727732008-12-23T13:07:00.000-08:002008-12-23T13:07:00.000-08:00I've also experienced this problem and have found ...I've also experienced this problem and have found no solution, aside from importing using an older version of Access (which is what I've been doing).Descriptionhttps://www.blogger.com/profile/16959273944397596309noreply@blogger.comtag:blogger.com,1999:blog-9102955.post-31590279279788068752008-12-03T09:31:00.000-08:002008-12-03T09:31:00.000-08:00Can you give some further information about this m...Can you give some further information about this macro you created? I'm not sure how to do a transfer action.<BR/><BR/>I have to find a way to make this work!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9102955.post-9707837080525383752008-11-14T12:47:00.000-08:002008-11-14T12:47:00.000-08:00Found a decent solution... when you import the te...Found a decent solution... when you import the text file using the "import text wizard", it breaks with that XML error. <BR/>However, if you create a macro using the TransferText action, and use the same import specification used in previous Access versions... it works!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9102955.post-18793168933361142222008-07-03T17:32:00.000-07:002008-07-03T17:32:00.000-07:00Just upgraded (?) to 2007 and within one day ran i...Just upgraded (?) to 2007 and within one day ran into this bug. Posted it on the MS Community board and Scott replied with this link.<BR/>Add me to the list.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9102955.post-47466674106444956352008-06-29T01:14:00.000-07:002008-06-29T01:14:00.000-07:00Same story here,"0130051234","EUR",20070301,"D",57...Same story here,<BR/><BR/>"0130051234","EUR",20070301,"D",57.92,"0000000000","064 ALDI ALPHEN AAN DE",20070301,"BA","","Pinautomaat 10:57 pasnr. 001","","","","",""<BR/><BR/>is a record from a file that won't import anymore. I compared all the import definition tables and all seems equal. <BR/><BR/>MartijnMartijnhttps://www.blogger.com/profile/07438122642409976727noreply@blogger.comtag:blogger.com,1999:blog-9102955.post-3055486444036487922007-12-07T07:11:00.000-08:002007-12-07T07:11:00.000-08:00I have a workaround, though it was NOT quick and e...I have a workaround, though it was NOT quick and easy. I changed my import specification to export the date field as a text field. Note that when I tried to just change the data type field from date to text, it still gave me the XML error. However, when I recreated my whole import specification from scratch, this time using text instead of date for that position, it worked. After importing the text file, I used the CDate function in Access to convert the text field into a date field.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9102955.post-11575476462653645602007-12-05T15:51:00.000-08:002007-12-05T15:51:00.000-08:00Yes, I am having the same problem and went looking...Yes, I am having the same problem and went looking to see if there is a fix or work around. I am *not* a happy Canadian University camper....Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9102955.post-73649788794543773062007-10-15T07:52:00.000-07:002007-10-15T07:52:00.000-07:00I agree, I have also reported exact same bug to Mi...I agree, I have also reported exact same bug to Microsoft technical support. We are using this feature a lot at my work and so this became very critical. As usual Microsoft has assigned me bug ID. Its been a while, more than 2 months, and there is no follow up from them.Unknownhttps://www.blogger.com/profile/16904145914329332722noreply@blogger.comtag:blogger.com,1999:blog-9102955.post-64231629280050787902007-08-31T07:24:00.000-07:002007-08-31T07:24:00.000-07:00I can not import text file, delimited by certain c...I can not import text file, delimited by certain characters, in Access 2007 which I was able to import it without any problem in access 2003 and previous version.<BR/><BR/>I do not have any date field in this text file even. They all are simple TEXT type field. I get this error message " The specification XML failed to validate against the schema. There is an error in the foloowing line of the XML document: |."<BR/><BR/>Anybody ???<BR/><BR/>Thanks in advanceAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-9102955.post-8008985378360712702007-05-11T06:22:00.000-07:002007-05-11T06:22:00.000-07:00oh, i feel your paindates of yyyymmdd format are t...oh, i feel your pain<BR/><BR/>dates of yyyymmdd format are the only ones that matter! <BR/><BR/>(assuming of course you really mean yyyyMMdd unless minutes are so important to you)<BR/><BR/>here in Aus we are doomed to face many date format issues in all US software and software platforms. even Joel sposlsky stuffs it up most of the time, ;-)<BR/><BR/>lb .; secretGeek.net ;.Anonymousnoreply@blogger.com