automate import

[sverre]

Hi

I have two text-files that I regularly import in a mdb. I have written
import specifications for both files. Can I write a macro to make Access
automatically import my text-files with the link-specs I have?

Many thanks in advance
Sverre

 

[Jeanette Cunningham]

sverre,
create a new macro
for the action choose transfer text
in the lower pane of the macro dialog
enter the appropriate value on each line.
There is quite good help availabe for each line, explaining what you need to
do in Access 2003.


Jeanette Cunningham -- Melbourne Victoria Australia

 

[a a r o n . k e m p f]

if you want to automate an ETL process like this-- then you should use
a real ETL tool.
Like Informatica, for example.

-Aaron

 

[Rastro]

Refer to other thread "Macro to import date from text file" 05/13/2008
I posted a procedure to select and import a txt file

Rastro