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

P

Pmeyer

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,
 
K

Klatuu

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import errors importing Text into existing table, header vs no hea 3
Batch Import 0
importing .dat files 2
Importing a text file 4
Export/Import .dat file extension 2
Importing a text (.txt) file into a 2003 database 0
Automate import of text-files 1
Error importing to Access - file was not imported 1

Top