 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / August 2005excel zero's
I need some help with excel. I am putting info into various tables (using excel) and sending them to a data base (in excel)with a macro. the data base has many variables and there is never a situation when all the variables are used when entering info into the table. Consequently, when the table info is sent to the database the unused variables have a zero value. this zero value causes havoc with analysis. I want to send info to the data base and leave all unused variables as blank cells for that subject. Is there a macro that can be written to do this or some other way? I tried to simply uncheck the zero values in the tools option menu but then all zero values including true zero values disappear, so this is not an option for me. This depends on how you are doing the import in the macro. Post the macro codes and if it uses any queries, send the SQL version of the query. Be aware that Macros are limited on what they can accomplish. It may be difficult to do with a macro. What is happening to you is not uncommon. The problem is that if an Excel cell is formatted as General (default) and no entry is made, Access sees it as Null. This does cause problems. It isn't that hard to fix, but we need to see what you are doing so we can provide the best resolution. > I need some help with excel. I am putting info into various tables > (using excel) and sending them to a data base (in excel)with a macro. [quoted text clipped - 7 lines] > zero values in the tools option menu but then all zero values including > true zero values disappear, so this is not an option for me. It sounds as if you're working in Excel, in which case this is the wrong place to ask. Try posting your question in the appropriate Excel newsgroup. If despite what you say you're storing the data in Access tables, try setting the default values of the number fields to Null instead of zero. >I need some help with excel. I am putting info into various tables >(using excel) and sending them to a data base (in excel)with a macro. [quoted text clipped - 7 lines] >zero values in the tools option menu but then all zero values including >true zero values disappear, so this is not an option for me. -- 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.