How to Import date and string values in the same column to access

[Pack10]

As part of one of our processes, I import a small table that has a column that contains date values with other values that contain "N/A". When I import it into my db, as a date field I lose the "N/A". If I make it a text field in the import file it becomes a numeric value. Whats the best way to handle this.

 

[dhookom]

Pack10,
It would help if you described better than "[red]it[/red] becomes a numeric value". What becomes numeric and what value does it start as and become?

I can guess that a value like 9/16/2011 becomes 40802 but that's just a guess.

Duane
Hook'D on Access
MS Access MVP

 

[Pack10]

I receive an excel file consisting on a client_ID, client_name, and transaction_date. In the column that contains the date, there will be some identified with "N/A". When I import the file into Access as a date field the N/A's come in blank.

If I change the date field in the excel sheet that I will import to a text field, the date values change to numeric values.
Hope this helps.

 

[PHV]

a date field the N/A's come in blank
I guess the date field come as Null instead of blank ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

Hope this helps"... not so much. I was really hoping you would provide sample values like I did.

I would import keeping the Excel file as is but import the column into a text field in Access.

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

The VALUES in Excel that have "N/A", actually #N/A!, are ERROR VALUES.

You do not want the error value in Access.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}