Import Data

[Brent]

I have a database application that basically analyzes data and gives the
user useful data on it. The issue is that the data it uses is imported
from a text file that a vendor sends us each week. I have everything setup
to use import setting but I was hoping to get out of the loop each week and
write a macro that prompts the user for the data path where the file they
want to analyze is located. Does anyone know what command or syntax to use
to accomplish this.

Thanks

 

[Steve Schapel]

Brent,

Is the data file have a different name/location each week?

You can use a TransferText action in a macro to do what you ask.

 

[Brent]

Yes the data file is named differently and the users can save that email
attachment anywhere and usually do Is there a command to make it ask you
for a path?

 

[Van T. Dinh]

If you use VBA (TransferText Method in VBA is the equivalent of TransferText
Action in Macros), the you can use code from the Access Web:

http://www.mvps.org/access/api/api0001.htm

 

[Steve Schapel]

Brent,

Yes.
=InputBox("Enter full path and file name")

 

[Brent]

Thanks

If you use VBA (TransferText Method in VBA is the equivalent of
TransferText
Action in Macros), the you can use code from the Access Web:

http://www.mvps.org/access/api/api0001.htm

 

[Brent]

I think I got what I needed from the post above but I was looking for it to
allow them to browse and click on the file.

Thanks

 

[Steve Schapel]

Brent,

Yes... but not with a macro