After I import my data from excel to Access one of ID field is text so when I change that t number it is setting to zero. Any solution to keep it number because need to merge tis data on I field.
Tried changing the format in Excel to number but after importin it is back to text
Thank you,
Lakshmi