TransferSpreadsheet Action

[Harry S.]

Hi all -

I am using the TransferSpreadsheet action to import data from a series of spreadsheets. Everything works fine except for that when I move the database (or the spreadsheets) to a different folder all of my links obviously break in the 'File Name' argument. Is it possible to have Access always look into the same directory in which the currently running .mdb file is located (without specifying the path)?

In other words, instead of entering;
'C:\Documents and Settings\User1\Desktop\Datafile\ABC.xls'
is there any way to simply enter
'ABC.xls'

I've tried using //ABC.xls or just ABC.xls and neither works.

Any help would be appreciated!

Thanks,
Harry

 

[Ken Snell]

Try this as the filename argument:

=CurrentProject.Path & "\ABC.xls"


--

Ken Snell
<MS ACCESS MVP>

Hi all -

I am using the TransferSpreadsheet action to import data from a series of
spreadsheets. Everything works fine except for that when I move the
database (or the spreadsheets) to a different folder all of my links
obviously break in the 'File Name' argument. Is it possible to have Access
always look into the same directory in which the currently running .mdb file
is located (without specifying the path)?

In other words, instead of entering;
'C:\Documents and Settings\User1\Desktop\Datafile\ABC.xls'
is there any way to simply enter
'ABC.xls'

I've tried using //ABC.xls or just ABC.xls and neither works.

Any help would be appreciated!

Thanks,
Harry

 

[Harry S.]

Perfect!
Thanks Ken

Harry


Try this as the filename argument:

=CurrentProject.Path & "\ABC.xls"


--

Ken Snell
<MS ACCESS MVP>

Hi all -

I am using the TransferSpreadsheet action to import data from a series of
spreadsheets. Everything works fine except for that when I move the
database (or the spreadsheets) to a different folder all of my links
obviously break in the 'File Name' argument. Is it possible to have Access
always look into the same directory in which the currently running ..mdb file
is located (without specifying the path)?

In other words, instead of entering;
'C:\Documents and Settings\User1\Desktop\Datafile\ABC.xls'
is there any way to simply enter
'ABC.xls'

I've tried using //ABC.xls or just ABC.xls and neither works.

Any help would be appreciated!

Thanks,
Harry