Importing .csv files into Access

[Dwight]

Hi,

The problem I'm having occurs when importing a .csv file.
I'm using the "Transfer Text" action in a macro, Import
delmited transfer type. There are a few data conversion
errors, otherwise the data imports into the table with no
problems. My issue occurs when I query the imported
table...the field I'm querying either contains an "X" or
is empty. If my statement is Not "X", the query returns
no records. However, if I copy and paste from Excel into
the table, the Not "X" statement works. I looked at the
data types in the table and the data itself, and I can't
quite figure out why the queries would act differently.
Can anyone help?

 

[Ken Snell]

My guess is that the TransferText put Null values in the records where "X"
was not in the data, but EXCEL has empty string in its cells.

Run an update query to convert Null values to empty string and see if that
helps.

UPDATE TableName
SET XField = ""
WHERE XField Is Null;