Is it impossible for access to import ZLS from .CSV ?!

[CJ_London]

unfortunately that will import "" rather than a zls as does my suggestion way back when

I've been doing some research and the problem is not limited to Access or even MS - Oracle, mySQL etc all suffer from the same problem.

A solution seems to be to link to the source file then write an append query to append data using something like

INSERT INTO myTable SET myFld1=iif(isnull(fld1),"",fld1) FROM LinkedTable

 

[namliam]

if you are importing a csv file with text delimiters set as " then the delimiters do not get imported. A ZLS is represented by "" so if you import "","A" then you will see the A (not "A") and Nothing or Null (not a ZLS) for the "". Setting the target table field to allow ZLS does not mean a ZLS will be imported. Setting the the target table field to Required does not mean a ZLS will be imported.

"" is a ZLS, in my book anyways, a null would not have any value as MS$ suggested or I have seen things like
,"NULL",
or
,NULL,
to represent actual NULL values in text files. Dealing with actual null values is always a challenge I think in tekst files (be it in csv or in xml)