Ms Access Error 3438
360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
posted 2007-Aug-18, 6:27 pm edited 2007-Aug-18, 6:32 pm ref: whrl.pl/RbhdQD posted 2007-Aug-18, 6:27 pm (edited2007-Aug-18, 6:32 pm) O.P. Hello, I'm trying to export a table from access ms 2002 to a text file but I just get this error:The data being exported does not match the format described in the Schema.ini file. (Error 3438)but I can not find a Schema.ini file besides an old one in C: drive which has not changed for years?I found info here about it support.microsoft.com/kb/225987UPDATE: https://support.microsoft.com/en-us/kb/225987 ok I figured it out, the problem was I was using the import spec where I had to create an export spec lol Archive View Return to standard view Industry news Submit news Previous articles Discussion forum Search Popular topics Community Rules Moderation FAQ Whirlpool FAQ Rep code of conduct Knowledge base Index Job board FAQ Post a http://forums.whirlpool.net.au/archive/804241 job Membership 747,827 registered members 13,599 visited in past 24 hrs 279 members online now 555 guests visiting now Big numbers 2,309,083 threads 51,813,027 posts 4,745,626 whims sent 4,585 wiki topics 1,689 modems & routers 74,927 features filled Broadband Choosing an ISP Broadband “NBN” Networking Modems/Routers Networking Voice over IP Peer to peer IT Industry Telecomms Web hosting Web development Programming Server management Companies Telstra Broadband Optus Broadband iiNet Group Internode TPG Eftel/ClubTelco/aaNet Exetel iPrimus Dodo Connections Other broadband Regional Last century International New Zealand ISPs Mobile Mobile carriers Wireless ISPs iPhone iPad Android phones Android tablets Windows Phone Other phones Computers Desktops Monitors/video Notebooks Peripherals Windows Apple Linux/BSD Life Jobs Education Graduate programs Finance Lifestyle Travel Entertainment Home theatre TV shows Movies Music Gaming Sport Lounges Automotive Photography Gadgets Home Green tech On the web Help Whirlpool FAQ Community rules Moderation FAQ Rep code of conduct Legal complaints Tips Scroll to top Sections Hardware database Knowledge base Job board Whirlpool.net.au Copyright Whirlpool.net.au ( Legal ) Bulletproof Networks Whirlpool powered byBulletproof Managed Hosting
Trying to export a table to .ansi formatted file. Keep getting error 3438: The data being exported does not match the format described in the Schema.ini file. Any ideas? GreenBelt74, Apr 19, 2006 #1 Advertisements Douglas J. Steele Guest Do http://www.office-forums.com/threads/how-can-i-resolve-error-3438.487598/ you think that the file does match what it says in the Schema.ini file? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "GreenBelt74" <> wrote in message news:... > Trying to export a table to .ansi formatted http://accessdatabaserecovery.blogspot.com/2010/01/error-message-after-exporting-ms-access.html file. Keep getting error > 3438: > The data being exported does not match the format described in the > Schema.ini > file. > > Any ideas? Douglas J. Steele, Apr 19, 2006 #2 Advertisements GreenBelt74 Guest How can ms access I see the Schema.ini file? "Douglas J. Steele" wrote: > Do you think that the file does match what it says in the Schema.ini file? > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "GreenBelt74" <> wrote in message > news:... > > Trying to export a table to .ansi formatted file. Keep getting error > > 3438: > > The data being exported does not match the format described in ms access error the > > Schema.ini > > file. > > > > Any ideas? > > > GreenBelt74, Apr 20, 2006 #3 Douglas J. Steele Guest Look in the same folder as the text file is in. If you can't find one there, what steps are you following when trying to export the data. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "GreenBelt74" <> wrote in message news:... > How can I see the Schema.ini file? > > "Douglas J. Steele" wrote: > >> Do you think that the file does match what it says in the Schema.ini >> file? >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no private e-mails, please) >> >> >> "GreenBelt74" <> wrote in message >> news:... >> > Trying to export a table to .ansi formatted file. Keep getting error >> > 3438: >> > The data being exported does not match the format described in the >> > Schema.ini >> > file. >> > >> > Any ideas? >> >> >> Douglas J. Steele, Apr 20, 2006 #4 GreenBelt74 Guest The text file doesn't exist yet; that's what I'm trying to create from a table I have. The steps I am following: - created a macro where only action is TransferText (this is how I've done this succesfully in the past). - in section on bottom of macro design view: - Transfer Type: Export Fixed Wi
Access database components in MS Word Merge format or MS Excel format is the common practice followed by database users. While exporting the database objects provides various benefits, it can also become a cause of Access database corruption. In many cases, the Access database becomes inaccessible and demountable. To regain the affected database data, you should restore the Access database from an updated backup. However, if you have not created any such backup or the backup fails to restore data, then you need to use advanced access recovery tools. Consider a practical example, where you receive the below error message when you export a table (Employee) from a Microsoft Access database (in .mdb format) to the Microsoft Word Merge format: "The data being exported does not match the format described in the Schema.ini file." Furthermore, you receive another error message if you use VBA (Visual Basic for Application) code: Run-time error ‘3438' Cause: The main cause behind the above error message is that when you export the Employee table for the first time, the field names of the table for the Microsoft Word Merge format get saved in the Schema.ini file. A schema.ini (schema information) file provides information about the general format of the file, column name and data types. So, if you again export the employee table, it does not match with previously exported fields. Another major reason behind mismatching fields can be Access database corruption. In both the cases, if you try to import the Employee table, you will receive the above error messages. Resolution: To resolve the errors, Microsoft suggests opening the schema.ini file by using Notepad and then modifying all the field names that are causing the problem. However, in case of database corruption