Numeric Field Overflow Error
in [Queries]
|
From: John W. Vinson on 4 May 2010 15:49 On Tue, 4 May 2010 11:50:01 -0700, Tracy <Tracy(a)discussions.microsoft.com> wrote: >The reason my boss chose to link to the excel file is that the information is >used by multiple departments, but the database that we use the information in >is only used by our department. So when there is an update, we make it on >the excel file and then run the append/delete query to update the append >table in the database. The excel file is saved on a common drive but the >database my particular department uses is only used by us, so its kind of >backwards from what you'd think it should be. ok... makes sense if you're dealing with benighted, abominable heathens who rely on Excel <bg> >Here is the SQL of the append query and the query I use to run the form off >of. > >Append Query: >INSERT INTO WarehouseInfo_Live >SELECT WarehouseInfo_Live_link.* >FROM WarehouseInfo_Live_link; > >Warehouse Info Display Query: > >(The 4 digit WhseID is the item that is selected via a combo box, and then >the related records are displayed on the form. It pulls from the table the >data from the live table is appended to.) What does the combo box have to do with anything??? Neither query references it. >SELECT WarehouseInfo_Live.WhseID, WarehouseInfo_Live.WhseName, >WarehouseInfo_Live.AddressLine1, WarehouseInfo_Live.AddressLine2, >WarehouseInfo_Live.City, WarehouseInfo_Live.State, WarehouseInfo_Live.Zip, >WarehouseInfo_Live.SpeedDial, WarehouseInfo_Live.Phone1, >WarehouseInfo_Live.Phone2, WarehouseInfo_Live.Fax, >WarehouseInfo_Live.Contact1, WarehouseInfo_Live.Email1, >WarehouseInfo_Live.Contact2, WarehouseInfo_Live.Email2, >WarehouseInfo_Live.Contact3, WarehouseInfo_Live.Email3, >WarehouseInfo_Live.WhseNumber, WarehouseInfo_Live.[Self Billing], >WarehouseInfo_Live.InvPrefix, WarehouseInfo_Live.CutOff, >WarehouseInfo_Live.HoursofOperation, WarehouseInfo_Live.[Important Notes], >WarehouseInfo_Live.[FEDEX Cutoff], WarehouseInfo_Live.DSO1, >WarehouseInfo_Live.DSO2, WarehouseInfo_Live.Billing, >WarehouseInfo_Live.Inventory, WarehouseInfo_Live.Credit, >WarehouseInfo_Live.Deployment, WarehouseInfo_Live.Transportation, >WarehouseInfo_Live.TransportationAnalyst, >WarehouseInfo_Live.ExpressWhsePlanner, WarehouseInfo_Live.CustomerService >FROM WarehouseInfo_Live; And are the fields in WarehouseInfo_Live in fact all Text fields? The error message sounds like you're trying to insert too large a number into a Number type field: might one of the Phone fields, or some other field consisting of all digits, actually be a Number field? -- John W. Vinson [MVP] |