import text file macro

[deekras]

i am looking to write a macro or some coding to import a text file.

i have a file in btrieve that may be changed every day (address changes, etc) i would like to delete the info that was valid after the last time i imported the data and put in the data that was valid as of last night. i can do this by importing and then searching for the file, etc. but i would like to write a macro to do it without my having to click all those buttons.

it is a text file, tab delimited.

 

[catt]

A macro takes all the individual steps you need to complete a task and performs them through one command (the macro).

List the steps for your process. Be very specific. Like Open table, delete records, close table, append new records, etc. Decide if you need to create delete or append queries and create them.

Open up a new macro and start listing your steps through Access' action menu. Make sure you describe your actions in the comment column, next to action column.

I usually create a database specifically for testing and debugging.

I hope this helps.