Hello,
My name is actually Manny, not Nick but am the new guy. I am trying to learn access on the go ( not much experience with code, little with macros) and am having issues with a few steps; adding a file name to each record I am importing to a single table and putting a manual date on each record. These records are coming from text files with IMB (intelligent mail barcode) files. Each record has 31 characters, each file can have 1 to 1,000,000 records. I will be adding new files on a daily basis and removing files older than 45 days. In Access, I am cutting each record into 5 columns: Barcode ID, STID, MID, Serial number, and Delivery point. I want to add the file name and date column when importing. I am using Access 2007. Is anyone willing to give a newby some help?
Thank you in advance for your help.
Manny from Illinois