Importing a text file to Access where the file name changes daily

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to do create a macro within Access to import a text file where
the file name changes daily ie there is a dialogue box where the user can
select the file required.

Any help would be much appreciated?

thanks
 
if you are using a macro, instead of a file name use
=inputbox("fred")

change "fred" to "what ever you want"

if you are using VB, replace the filename string with InputBox

If you are using a query, replace the filename string with [fred]
using square brackets.

(david)
 
Hi David

Thanks for your help

I think this is beyond my very limited skills- I was hoping I could use the
in bulit macro function within Access in some way!


david@epsomdotcomdotau said:
if you are using a macro, instead of a file name use
=inputbox("fred")

change "fred" to "what ever you want"

if you are using VB, replace the filename string with InputBox

If you are using a query, replace the filename string with [fred]
using square brackets.

(david)

Dixie said:
Is it possible to do create a macro within Access to import a text file where
the file name changes daily ie there is a dialogue box where the user can
select the file required.

Any help would be much appreciated?

thanks
Click to expand...
Click to expand...
 
Just leave the file name out of the macro

(david)

Dixie said:
Hi David

Thanks for your help

I think this is beyond my very limited skills- I was hoping I could use
the
in bulit macro function within Access in some way!


david@epsomdotcomdotau said:
if you are using a macro, instead of a file name use
=inputbox("fred")

change "fred" to "what ever you want"

if you are using VB, replace the filename string with InputBox

If you are using a query, replace the filename string with [fred]
using square brackets.

(david)

Dixie said:
Is it possible to do create a macro within Access to import a text file where
the file name changes daily ie there is a dialogue box where the user
can
select the file required.

Any help would be much appreciated?

thanks
Click to expand...
Click to expand...
Click to expand...
 
Thanks David

That works fine

david epsom dot com dot au said:
Just leave the file name out of the macro

(david)

Dixie said:
Hi David

Thanks for your help

I think this is beyond my very limited skills- I was hoping I could use
the
in bulit macro function within Access in some way!


david@epsomdotcomdotau said:
if you are using a macro, instead of a file name use
=inputbox("fred")

change "fred" to "what ever you want"

if you are using VB, replace the filename string with InputBox

If you are using a query, replace the filename string with [fred]
using square brackets.

(david)

Is it possible to do create a macro within Access to import a text file
where
the file name changes daily ie there is a dialogue box where the user
can
select the file required.

Any help would be much appreciated?

thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top