 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / August 2005Export Query to Fixed Format File
Hi there, I have a query that I need to export to a fixed format text file, but when I try to do it, I either get an error message that says my data is not updateable or nothing happens at all. Any suggestions? Thanks in advance. Janet Hi Janet, 1) What's the file extension? If it's something other than .txt, see This http://support.microsoft.com/?id=304206 2) Are you using an export specification or schema.ini file? >Hi there, > [quoted text clipped - 3 lines] > >Janet -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. John, I just opened my query, then went to File, Export, then tried to save my query as a .txt file. I need a fixed format text file. Thought it would be simple. But instead, either nothing happens (no wizard) or I get an error saying my recordset is not updateable. Thanks. Janet > Hi Janet, > [quoted text clipped - 15 lines] > > Please respond in the newgroup and not by email. Janet, The next step is to re-register ACCWIZ.DLL. Problems with this can stop the export wizard appearing at all. While you're at it, also re-register mstext40.dll. One way to re-register a DLL: 1) Locate it (usually all these are in the Windows\System32 or WINNT\System32 folder. 2) Locate the file regsvr32.exe. 3) Drag the DLL file's icon onto the regsvr32.exe icon. If that doesn't fix it, please post back with more information: 1) The exact error message and error number you are getting. 2) Do you get this problem exporting any query or just this particular one? Do you get the problem exporting from the Northwind sample database? 3) What versions and service packs of Windows and Office are you using? >John, > [quoted text clipped - 24 lines] >> >> Please respond in the newgroup and not by email. -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.