By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,472 Members | 2,195 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,472 IT Pros & Developers. It's quick & easy.

import from textfile & datestamp?

P: 1
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
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 344
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.