excel zero's

  • Thread starter Thread starter malt
  • Start date Start date
M

malt

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.
 
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.
 
Back
Top