Import text wizard, Advanced button

  • Thread starter Thread starter pgarcia
  • Start date Start date
P

pgarcia

When importing a text file, could I have a expression somewhere when
importing field 3 and it is = to 5 change 5s to 4s? Like so: Expr1:
IIf([Field3]=5,4,[Field3])

Thanks
 
No. But you can import the text file into an interim table, then use an
append query to copy the data to the permanent table -- and do the
conversion from 5 to 4 in that append query.
 
Back
Top