Input Mask for importing

[Kila]

I have a table that I copy into daily from a shared Excel spreadsheet. I am trying to minimize the amount of touching up the data needs. What input mask should I use so that a field with four numbers...1234 (for example) will be converted to a nine-digit number with leading zeros (000001234) when the data is imported. I would like the nine-digit number to be saved.

Also, is there a way to have a date field import the date only & ignore any text?

 

[RV]

will be converted to a nine-digit number with leading zeros

Numeric doesn't come with leading zero's.
You can only use leading zero's if you'd use datatype Text.

Also, is there a way to have a date field import the date only & ignore any text?

Dates do not come with text, or do you mean you've got the month reflected in the month name?

RV

 

[Kila]

I don't mind saving it as text, I just want five leading 0s on every one. Actually, what I *really* want to do is just copy the darn rows directly into the correct table in my database, but my SSN field (000-00-0000) errors out every time I paste into it. I am trying to "cheat", by pasting it into another table that will convert those numbers (1234 --> 000001234) so that I can then copy and paste into the correct table.

With regard to the date field, the original spreadsheet has occasional annotations in text (in the date field) that I would like to ignore. I have been going in & deleting all that mess, but I would like to save this step if I can.

Thanks for our help.