Insert Into problem in access

[Lhuffst]

I am trying to use
insert into tblexport (f1...f10)
Select f1..f10 from qryname
Where condition

This works fine as long as each field on the select has a value. How do I insert a null value if the field is empty? The table tblexport has allow null fields set to yes.

 

[JoeAtWork]

I believe it will just insert the Null fields, which should be OK since you say tblExport allows null values.

 

[Zion7]

Possibly assign alternate values, to subquery?

INSERT INTO tblExport(f1,f2,...
SElect FROM qryImport(Nz(f1,""),Nz(f2,"")

I believe it will accept Empty string values,
as opposed to null values.