A97: Filling a field with File Name and date

[RonMcIntire]

All:

OBJECT
I am importing a .csv file programmitically into a table through the built-in TransferText function.

PROBLEM
I would also like to insert the imported file name, date and created time stamp into defined fields in the table.

QUESTION
Is there a way to do it? If so, how?

Thanks,

Ron

 

[dhookom]

I doubt you can do this from the transfertext function. You could run an update query after the records have been imported.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[RonMcIntire]

Duane:

Thanks for your response. I'll see how that works.


Ron