Automating import and export

[trotta]

I am fairly new to Access. I know this is easy but I do not know where to start.
I would like to automate this daily process: In this order import or link, (not sure which is the best option) a fixed width table, add an ascending number to the end of each of the records, reverse the order, and finally export to fixed width .txt documents depending on the quantities in one field. There would be 3 text files exported, max.

Thank you for the help.

T.

[June7]

Not exactly easy and depends on what you mean be 'automate'. Some event must occur to trigger code - like a button click or form open.

Import the data to a table with an autonumber field. This will generate the sequential number.

Review http://msdn.microsoft.com/en-us/libr.../ff835958.aspx

[redbull]

If you can make the import routine or macro or HOWEVER your going to do the import... then you can put a macro in the scheduled tasks section of windows to fire off the automation at a specific time. I have a couple machines that run a wide array of things automatically at specific times and this is how I handle it.

[redbull]

If your going to be doing it from VBA and not within macros etc etc... Then you can use a batch file to open your database.. have the database open a form on load, (Datebase tools ~> startup) THEN>>>>> on form load, you put your import etc etc etc....


In the scheduled tasks section you write a batch file like this...

@echo off
start MSACCESS.exe "C:\FILEPATH TO DATABASE.mdb"

Have that batch fire off.. and kaboom your done.

[June7]

I also use a batch file (VBScript) that Windows Task Manager runs according to schedule. The script closes all instances of Access application then opens my db. A form opens by default when db opens and code behind that form's Open event immediately executes.