Ms Access Error 3349 Numeric Field Overflow
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > How to avoid error: Run-time error '3349' Numeric field overflow when executing a rountine in Access 2003 application? Want to Advertise Here? Solved How to avoid error: Run-time error '3349' Numeric field overflow when executing a rountine in Access 2003 application? Posted on 2014-07-07 MS Access 1 Verified Solution 7 Comments 1,179 Views Last Modified: 2014-09-23 I am developing an Access 2003 application using an ADP type file with SQL Server as the back end database. I have a routine in my application that executes a stored procedure dbo.procFlToLN which produces a result set into a table titled "dbo.tblFlToLN". As for the file layout of the fields in table tblFlToLN there Data Types are all "nvarchar" except 1 field that is of Data Type "datetime": When my routine executes the following statement after the stored procedure, I get the error: Run-time error '3349': Numeric field overflow. Do you know how I can resolve this issue? DoCmd.TransferSpreadsheet acExport, 8, "dbo.tblFlToLN", ExportedFile, True, "" 0 Question by:zimmer9 Facebook Twitter LinkedIn Google LVL 84 Active today Best Solution byScott McDaniel (Microsoft Access MVP - EE MVE ) I'd suspect one of these: Right(C.OfficeNumber,3) + ' ' + C.CustomerNumber AS [Account Number], C.DateOfBirth AS [Date Of Birth] You might try using CAST or CONVERT in the Stored Procedure to Go to Solution 7 Comments LVL 10 Overall: Level 10 MS Access 1 Message Active today Expert Comment by:HuaMinChen2014-07-08 Check all columns one by one. It should be due to data mismatch there. 0 LVL 48 Overall: Level 48 MS Access 47 Message Active today Expert Comment by:Gustav Brock2014-07-08 You probably have at least one field which contains digits only. Even though the field type is Text, it may be exported as a number. If so, you may try to prefix it with a single quote: ' /gustav 0 LVL 84 Overall: Level 84 MS Access 83 Message Active today Expert Comment by:Scott McDaniel (Micro
Custom Search UtterAccess Forums>Microsoft® Access>Access Queries2 Pages 12> (Go to first unread post) Numeric field overflow. (Error 3349) Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code Archive|-- Access Knowledgebase / FAQ|-- Access TutorialsMicrosoft® Access|-- Local Access User Groups (AUGs)|-- Interface Design|-- Access Q and A|-- Access Tables + Relationships|-- Access Queries|-- Access Forms|-- Access Reports|-- Access Macros|-- Access Modules|-- Access Date + Time|-- Access Errors + Error Handling|-- Access Built-in Functions|-- https://www.experts-exchange.com/questions/28471125/How-to-avoid-error-Run-time-error-'3349'-Numeric-field-overflow-when-executing-a-rountine-in-Access-2003-application.html Access Searching + Data Mining|-- Access Records|-- Access Security|-- Access Automation|-- Access Database Container|-- Tool bars, Menu bars + Ribbon|-- Access Services (Web Databases)|-- Access Data Access Pages (Deprecated)|-- Access Data Projects - ADP|-- Access Runtime, Packaging & DeploymentAnd More...|-- Microsoft SQL Server|-- SQL Server Reporting Services|-- Microsoft SharePoint|-- Microsoft Internet Explorer|-- http://www.utteraccess.com/forum/Numeric-field-overflow-t1096168.html Visual Basic 6 and Earlier|-- Visual Basic 2003 and Later|-- ASP and VBScript|-- Web Development|-- PHP, Perl, MySQL and Postgres|-- Other Database Engines|-- BI Tools and Applications|-- JAVA and C#|-- GraphicsMicrosoft® Office|-- Microsoft Excel|-- Microsoft Excel FAQs|-- Microsoft Word|-- Microsoft Outlook|-- Microsoft PowerPoint|-- Microsoft FrontPage/Exp. Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- Q & A - UtterAccess.com Forums|-- Q & A - Access Wiki Options dustwebView Member Profile Jan 26 2006, 12:03 PM Post#1Posts: 440Joined: 5-April 05Hello,I am getting a Numeric field overflow. (Error 3349) message when I run a macro. The maco runs 3 queries.1st query is runs deletes the contents of my table2nd query appends data from a linked csv file to my table3rd query deletes all null records or records that contain "2"Any help is much apprciated.ThanksDUSTWEBcheekybuddh
FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts http://www.tek-tips.com/viewthread.cfm?qid=952596 Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other/access-make-table-query-error-numeric-field/f18150de-a266-4717-90d5-d8805c1e378f By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code ms access below into your site. Microsoft: Access Modules (VBA Coding) Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft: Access Modules (VBA Coding) Forum Run Time Error 3349 Numeric Overflow thread705-952596 Forum Search FAQs Links MVPs Run Time Error 3349 Numeric Overflow Run Time Error 3349 Numeric Overflow strangeryet (Programmer) (OP) 16 Nov 04 14:14 I am getting an error when I try to import an excel file; However I did not get this error prior ms access error to splitting the database.There is an Account number field in the excel file that will contain an account number or all nines (99999999).When I delete the records that have nines (the ones that are aligned to the left in the cell), the import works.But why did the import work prior to the split without removing these records? I did a search on the web and found a few areas where other people have experienced the same thing, but there were no resolutions. Perhaps someone on this site can help? Thanks RE: Run Time Error 3349 Numeric Overflow SkipVought (Programmer) 16 Nov 04 14:40 Hi,Is the AccountNumber FIELD a NUMBER or TEXT type?Probably should be TEXT. Skip, Be advised: Researchers have found another Descartes trueism, "Cogito ergo spud.""I think; therefore, I YAM! RE: Run Time Error 3349 Numeric Overflow strangeryet (Programmer) (OP) 16 Nov 04 14:48 I tried formatting the Account Number cell as a number, because when it gets imported into the Access table the field is defined as a Long Integer. However I noticed there is a little green triangle in the upper left corner of the cell in Excel. Do you know what this means?I suppose that these particular cells are coming through as text. I then deleted all of
be down. Please try the request again. Your cache administrator is webmaster. Generated Wed, 19 Oct 2016 08:03:41 GMT by s_ac4 (squid/3.5.20)