Hello,

While importing a file in access - I would like to put a datestamp within
the imported file. For example: Import an excel file, I would like to have
new column created called "DateStamp" of the date that the file was imported
for every record. Any ideas?

Thanks in advance
Y

use SQL Server ETL tools like DTS or SSIS.
they are 100 times more powerful than Jet macros



On Aug 12, 6:06*am, Vi <V...@discussions.microsoft.com> wrote:
> Hello,
>
> While importing a file in access - I would like to put a datestamp within
> the imported file. For example: Import an excel file, I would like to have
> new column created called "DateStamp" of the date that the file was imported
> for every record. Any ideas?
>
> Thanks in advance
> Y

On Aug 12, 8:06*am, Vi <V...@discussions.microsoft.com> wrote:
> Hello,
>
> While importing a file in access - I would like to put a datestamp within
> the imported file. For example: Import an excel file, I would like to have
> new column created called "DateStamp" of the date that the file was imported
> for every record. Any ideas?
>
> Thanks in advance
> Y

If you're importing all of this into an existing table, just modify
the table structure to add the date field and then after the import,
just run an update query on the table.

UPDATE MyTable
SET DateStamp = Now()
WHERE DateStamp IS NULL;

ignore arron kempf. He is a known troll.
peitlinden has the answer, but to add on to it, if your import creates the
table, it will not have an additional field for you to update with a
timestamp.
I would suggest you create a table to receive the Excel data. Import your
excel data to the existing table then run the update query to add the
timestamp.
Now, a way to get a more accurate timestamp would be, instead of importing
the excel data directly, link to the excel sheet. Then run an append query
that copies the data from the linked excel table to the Access table and
includes a calculated field that puts Now() in the timestamp field of the
Access table.
--
Dave Hargis, Microsoft Access MVP


"Vi" wrote:

> Hello,
>
> While importing a file in access - I would like to put a datestamp within
> the imported file. For example: Import an excel file, I would like to have
> new column created called "DateStamp" of the date that the file was imported
> for every record. Any ideas?
>
> Thanks in advance
> Y

Thank you very much.

"Klatuu" wrote:

> ignore arron kempf. He is a known troll.
> peitlinden has the answer, but to add on to it, if your import creates the
> table, it will not have an additional field for you to update with a
> timestamp.
> I would suggest you create a table to receive the Excel data. Import your
> excel data to the existing table then run the update query to add the
> timestamp.
> Now, a way to get a more accurate timestamp would be, instead of importing
> the excel data directly, link to the excel sheet. Then run an append query
> that copies the data from the linked excel table to the Access table and
> includes a calculated field that puts Now() in the timestamp field of the
> Access table.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "Vi" wrote:
>
> > Hello,
> >
> > While importing a file in access - I would like to put a datestamp within
> > the imported file. For example: Import an excel file, I would like to have
> > new column created called "DateStamp" of the date that the file was imported
> > for every record. Any ideas?
> >
> > Thanks in advance
> > Y

Ignore the m Aaron. He's just letting off steam. Or methane.

As to importing and adding a date stamp, if you import to an
existing table, just add the column to the end of the table, with
type = Date/Timeand set its default value to now(). Any records
added will have the field populated.

If you have Access create a new table for each import, you add the
column you will need to add the column, and run an update query to
set the value right after importing.

You might be able to set the additional column using an import
specification, but I've never experimented with that.


Q


"a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf@gmail.com>
wrote in
news:898d29a5-1a6e-4442-aa85-e05ff86a4f69
@o40g2000prn.googlegroups.co
m:

> use SQL Server ETL tools like DTS or SSIS.
> they are 100 times more powerful than Jet macros
>
>
>
> On Aug 12, 6:06*am, Vi <V...@discussions.microsoft.com> wrote:
>> Hello,
>>
>> While importing a file in access - I would like to put a
>> datestamp within the imported file. For example: Import an excel
>> file, I would like to hav
> e
>> new column created called "DateStamp" of the date that the file
>> was impor
> ted
>> for every record. Any ideas?
>>
>> Thanks in advance
>> Y
>
>



--
Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com **

it's not called a TIMESTAMP.

It's called a date column.

timestamp is something completely different, thanks

-Aaron


On Aug 12, 8:06*am, Klatuu <Kla...@discussions.microsoft.com> wrote:
> ignore arron kempf. *He is a known troll.
> peitlinden has the answer, but to add on to it, if your import creates the
> table, it will not have an additional field for you to update with a
> timestamp.
> I would suggest you create a table to receive the Excel data. *Import your
> excel data to the existing table then run the update query to add the
> timestamp.
> Now, a way to get a more accurate timestamp would be, instead of importing
> the excel data directly, link to the excel sheet. *Then run an append query
> that copies the data from the linked excel table to the Access table and
> includes a calculated field that puts Now() in the timestamp field of the
> Access table.
> --
> Dave Hargis, Microsoft Access MVP
>
> "Vi" wrote:
> > Hello,
>
> > While importing a file in access - I would like to put a datestamp within
> > the imported file. For example: Import an excel file, I would like to have
> > new column created called "DateStamp" of the date that the file was imported
> > for every record. Any ideas?
>
> > Thanks in advance
> > Y