SS# field after link to .csv created

  • Thread starter Thread starter lndsy
  • Start date Start date
L

lndsy

I have created a link table in Access to a .csv file that
I download regularly from our company's payroll db.

I have 3 update tables that are dependent upon the SS#
field of the link table and another table in my db.

The SS# field in the link table is in text format and I
have tried several things, but it does not show the first
digit of the SS#'s that start with 0, which does not
allow the update queries to run correctly.

Is there anything that I can do that will make the SS#
field formatted to show the 0's at the beginning of the
numbers?

Thank you in advance.
 
i don't think that formatting is going to help you. a query will match the
actual values in the fields, not the formatting. suggest you try adding a
calculated field to the query, something like

WholeSSN: IIf(Len([SSN])<9, "0" & [SSN], [SSN])

i'm assuming that [SSN] is not saved with the "dashes" in each value. if the
dashes are there, try changing from <9 to <11.

match records for the update on WholeSSN, rather than SSN.

hth
 
When you import it, you may want to change the type of field from numeric to tex

Edmun
MCP - Access and SQL Serve

----- lndsy wrote: ----

I have created a link table in Access to a .csv file that
I download regularly from our company's payroll db

I have 3 update tables that are dependent upon the SS#
field of the link table and another table in my db

The SS# field in the link table is in text format and I
have tried several things, but it does not show the first
digit of the SS#'s that start with 0, which does not
allow the update queries to run correctly.

Is there anything that I can do that will make the SS#
field formatted to show the 0's at the beginning of the
numbers

Thank you in advance
 
Back
Top