Importing a file - with timestamp (datestamp) within the imported

[Vi]

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

 

[a a r o n . k e m p f]

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

 

[pietlinden]

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;

 

[Klatuu]

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.

 

[Vi]

Thank you very much.

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.

 

[a a r o n . k e m p f]

it's not called a TIMESTAMP.

It's called a date column.

timestamp is something completely different, thanks

-Aaron