Ok i have an access database that is used to run reports off extracts from excel. I import the extracts from the main db, and run macros in access on them to fill tables. I am getting data type conversion errors on a text field that holds a number because there are accidental letters in the field on some records. the excel sheet and the access database are set up for those fields to be text anyway, so why is access thinking they are all supposed to be numbers? any ideas?
2007-09-13 03:59:04 · 3 answers · asked by Mike D 2 in Computers & Internet ➔ Programming & Design
its definatly that field, i get an error from the macro telling me which field threw the error. Basically every time theres a char in the text field rather than a number, it errors.
2007-09-13 04:13:49 · update #1
I would check how you have the different fields for the table formatted. Make sure the settings for each field are correct. You may also want to go back and format each column in your Excel file to the proper format. There may be one cell or one field that is formatted wrong.
2007-09-13 05:46:43 · answer #1 · answered by devilishblueyes 7 · 0⤊ 0⤋
Perhaps it is not that field that is causing the problem. I would systematically go through every field in the Access db, and make sure they match the datatypes coming in. I have run into this sometimes myself, and usually I end up changing all of the Access fields to text fields to make sure there are no errors. Access is pretty good about implicitly converting text to numbers for calculations, so it's usually not a problem. Good luck.
2007-09-13 04:11:50 · answer #2 · answered by Anonymous · 0⤊ 0⤋
look - you are able to % to "get exterior information" regardless of the undeniable fact that this is going to easily be a linked table. the perfect way is to layout your table so as that the sector order suits your excel spreadsheet or if it would not - regulate your excel spreadsheet so as that the column order and codecs experience those in get entry to then purely replica and paste the information. once you're having hassle insert some clean rows into the perfect of your spreadsheet then replica the perfect line of your get entry to database into the perfect of your spreadsheet - then experience the columns. to stick into get entry to: spotlight all information mandatory in excel then press "Ctrl+C" In get entry to click interior the left margin on the clean row on the backside of the table then press "Ctrl+V" Be warned. get entry to does no longer settle for formatting utilized to the incoming information. the information ought to be formatted first. Use the format painter in excel in case you have hassle.
2016-11-10 08:01:25 · answer #3 · answered by durrett 4 · 0⤊ 0⤋