Access 2003 Import

[ddw23]

Hi All.
I am working in Access 2003. I am importing a text file (import.txt) and saving specifications.
Once I get the txt file imported, I run the following queries:

1. cRQs in N,A,P Status (Yr End) 1 CONVERT dates (within the txt file)
Converts the text dates to mm/dd/yyyy
2. cRQs in N,A,P Status (Yr End) 2 APPEND
Appends the converted dates text file to the main table
I had to add another field to the main table to hold the dept names.
I also have the main table so that once the dates are converted I can change it from a text to a date filed.
3. cRQs in N,A,P Status (Yr End) 3 ADD depts.
Updates the added filed with the department names which are based off of certain characters in an ID field.
This is a reoccurring function.

What I want to happen is the following:
When the database opens…
1. Delete old data in all main tables being used.
2. Import all txt files using proper specifications.
3. Convert date field within txt file.
4. Append to main tables.
5. Add depts.
6. I want this to happen as soon as the database’s main form is opened.
7. Within these processes, not have to have the user select “Yes” to proceed with any query actions.

Can’t this all be put in a code? I want to make this program less user interaction (user friendly) as possible. Am I asking for too much???
Can someone give me some suggestions please?
Thanks to all!!!

 

[gemma-the-husky]

yes it can all happen -

use the switchboard open event, or a splashscreen open event, whichver comes first

I would probably do this with a control button prompt, even though you want it to be invisible, just so the user knows something is happening.

2. just work through it all one stage at a time, until its all debugged.