If I understand you correctly, Excel doesn't support the concept of the NULL
data type that you have in a database. To get that you may need to run a macro
from the database to replace, say, a "flag" value with a database NULL.
On Mon, 9 May 2005 11:03:02 -0700, "Nither1"
wrote:
I plan to use an Excel spreadsheetand cut and paste data into a database. I
need to replace blank cells in the spreadsheet with nulls. How can I
accomplish this?
|