Last post Mar 05, 2021 12:33 AM by vj78
Mar 04, 2021 08:05 PM|vj78|LINK
I need to import CSV to Access.
My first field is an ID with leading zeros.
It drops the leading zeros?
Mar 04, 2021 09:08 PM|Mikesdotnetting|LINK
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.
Mar 05, 2021 12:33 AM|vj78|LINK
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
Per your suggestion, I pre-created the table with id as a text field and its working.