Importing Text Data

[Steve Smith]

Hi All

I use Access to process engineering test data. The test instruments output
test data as comma delimitted ascii text files with a .txt extension. For
the last few years i have been importing the data manually but now volume
and the need for others to also do this, means i need to automate it.

I am trying to write a macro that clears a table called [data], then gets
the path and filename from a second table [Input File].input file and
imports this file with a Beng05 Import Specification. However the standard
Macro designer does not allow a look up for the file name. Presumably this
needs to be done with SQL.

Has anyone got any better ideas for doing this?

Steve

 

[Ken Snell \(MVP\)]

Yes you can look up info in a macro. For the Filename argument, use an
expression (note that you must include the = character):

=DLookup("PathandFilenameField", "InputFile")