<div>
Just open the table that your appending to in design mode and on your date/time field, set the default to Date() or Now() (if you need the time).<br />
<br />
Jim.
</div>


Just open the table that your appending to in design mode and on your date/time field, set the default to Date() or Now() (if you need the time).

Jim.

<div>
Or are your creating a brand new table?<br />
<br />
Jim.
</div>


Or are your creating a brand new table?

Jim.

<div>
I will be appending the data to an existing table. &nbsp;The field for the date &amp;&nbsp;time on the file will be in a field called 'filedate'.
</div>


I will be appending the data to an existing table.  The field for the date & time on the file will be in a field called 'filedate'.

<div>
Then just set the default value for FileDate to Now() or Date(). &nbsp;It will be filled in automatically as soon as the record is appended.<br />
<br />
Jim.
</div>


Then just set the default value for FileDate to Now() or Date().  It will be filled in automatically as soon as the record is appended.

Jim.

<div>
FSO=File System Object. &nbsp;Part of the FSO is the creation date and time. &nbsp;That's what I need to import. &nbsp;Not the Now() or Date().<br />
<br />
Thanks
</div>


FSO=File System Object.  Part of the FSO is the creation date and time.  That's what I need to import.  Not the Now() or Date().

Thanks

<div>
<div class="content wysiwyg-content">
I am currently writing a macro to import a file. &nbsp;I want to append the file date/time with each record. &nbsp;This way, I can prequery the data table and stop the file from being imported more than once.<br />
<br />
Thanks,<br />
Doug
</div>
</div>


I am currently writing a macro to import a file.  I want to append the file date/time with each record.  This way, I can prequery the data table and stop the file from being imported more than once.

Thanks,
Doug

Import File with FSO Date and Time

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.