Import Empty Strings from CSV?

[whdyck]

I'm using Access 2003.

If I import a CSV file where every field is wrapped in double quotes, an empty string in the CSV imports as a NULL in the target table. Is there any way for that column to import as an empty string instead?

I don't see anything in the import specification screen that allows me to change this behavior.

Here's what a typical CSV record might look like:

"ABC","",123"

I'd like the second field to import as an empty string.

Thanks for any help you can give.

Wayne

 

[jdraw]

After the import, you could run an Update to set all NULL to "". Just a thought.

 

[whdyck]

After the import, you could run an Update to set all NULL to "". Just a thought.

Yes, I had thought of that, but it would be a lot cleaner if I could do it during the import.