automation of importing a text file into an existing MS Access dat

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to automate the procedure of taking a text file from my PC and
importing the data in a text file based on 1 column, but the 1 column's data
that is the key field in Access has 4 leading 0's which isn't found in my
text file.

Does anyone have any ideas on how I can accomplish this.

Thanks,
 
How are you doing the import? It will help identify exactly where to put the
fix. All you need to do is add the four 0's at the front of your text column:

MyField = "0000" & MyField
 
Back
Top