I have no idea why this is happening. But I wish it would stop.
I have a csv file which I import into Access monthly. I have a field that is a SIC Code field. Essentially SIC codes are numbers but they mean nothing in terms of numbers so I have them in my CSV files as text.
When I import this to Access, Access automatically imports it as a double. This is really messing me up in my Crystal reports as my look up table to map the SIC codes are text.
My fix has been to switch the double back to text to get this to work, but I am training newbies on some of the Access fields and don't want to overwhelm them with too much right now. I want it as automated for them as possible.
Does anyone know why Access wants to do this. This has happened to me a few times in other fields and it drives me crazy.
Thanks
I have a csv file which I import into Access monthly. I have a field that is a SIC Code field. Essentially SIC codes are numbers but they mean nothing in terms of numbers so I have them in my CSV files as text.
When I import this to Access, Access automatically imports it as a double. This is really messing me up in my Crystal reports as my look up table to map the SIC codes are text.
My fix has been to switch the double back to text to get this to work, but I am training newbies on some of the Access fields and don't want to overwhelm them with too much right now. I want it as automated for them as possible.
Does anyone know why Access wants to do this. This has happened to me a few times in other fields and it drives me crazy.
Thanks