469,588 Members | 2,741 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,588 developers. It's quick & easy.

import from textfile & datestamp?

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!
Jul 23 '07 #1
1 1688
Lysander
344 Expert 100+
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
Jul 24 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Sigurd Bruteig | last post: by
4 posts views Thread by mibispam | last post: by
1 post views Thread by joel.sjoo | last post: by
17 posts views Thread by Phil M | last post: by
9 posts views Thread by a | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.