Import a CSV to Access

Question

User1997074450 posted

I need to import CSV to Access. 

My first field is an ID with leading zeros.

It drops the leading zeros?

Answer 1

User-821857111 posted

You need to make sure that the target column's data type is text if you want to retain the leading zeros. Although I wouldn't recommend doing that. What useful function do the leading zeros performance from an application logic point of view? If they are only used for display, then develop a function for including them whenever you display an ID.

Answer 2

User1997074450 posted

Yes,  you are right have leading zero's in ID field is questionable. I think there are other Id's in the system but with my current knowledge of the system I am restricted to that particular ID with leading zero as that is unique field that can be used to compare records.

Per your suggestion, I pre-created the  table with id as a text field and its working.

Thanks :)