Re: programmatic linking to external tables

Hi,

You might want to have a look at the "TransferSpread***" action in the VBA Help.

If you combine that with this FileOpen Dialog code,
http://www.mvps.org/access/api/api0001.htm
you will have a semi-automated process.

I use this to bring in daily sales data from an Excel file to a temp table. There it
gets massaged, then appended to the Sales table. Works really well

hth,
John

---------------------


"Ben" wrote

[...]
> I like to ask, if there's an programmatic way to link and query each day's
> data, since the directory structure is static and the file naming convention
> is consistent.


.