dynamic report's record source

T

Tim

I import a txt file and based on that txt file I make a table and a report. I
can do that manually. But importing txt files is routinely done daily, so I
think the record source of the report need to be done programmatically. I am
done the importing part but I am stuck at the report record source. Can you
help me with that?
Thank you.
 
K

Klatuu

Are you importing into an existing table, adding an additional table (ie each
import creates a new table), or deleting the old table before importing the
new one?
 
K

Klatuu

Okay, thanks
Instead of deleting the table each time, just delete the data out of it and
import the text file into the existing table. Then you wont have to do any
coding to identify the record source for your report. Just use the table or
a query based on the table as the recordsource.
 
T

Tim

wow, that's simple!
Thank you.

Klatuu said:
Okay, thanks
Instead of deleting the table each time, just delete the data out of it and
import the text file into the existing table. Then you wont have to do any
coding to identify the record source for your report. Just use the table or
a query based on the table as the recordsource.
Click to expand...
 
Top