import from textfile & datestamp?

[jpgoeth1]

Hi,

I'm brand-new to access 2007 and I need a little help building my first database.

I'm importing from a text file and I'd like to add a datestamp as a separate column. This would hold the current stamp for the date submitted. Is there a way to do this during the import, or would I need to run a macro or something afterwards (or possibly add that data to the source file first?)

Thanks!

[Lysander]

Hi,

I'm brand-new to access 2007 and I need a little help building my first database.

I'm importing from a text file and I'd like to add a datestamp as a separate column. This would hold the current stamp for the date submitted. Is there a way to do this during the import, or would I need to run a macro or something afterwards (or possibly add that data to the source file first?)

Thanks!

Create a table that has the fieldnames you want to import. Add another field called When that is a date/time field. Make it required, and set the defaults to date()

When you import your text file into this table, the When field will be set to the date and time on the PC when you did the import