Adding date of import

[Pauline]

Hi All

I download data from one computer system and import the
data into an Access database that is used for reporting
purposes.

The data is saved as a text file from the original system
and I run a macro to import the data to the database.

What I need to do is, when I import the text file I want
the table to show the date of import.

eg: Table - Snapshot

Fields:
Pers No
Start Date
End Date
Fraction
Name
Title
Gender

After running the macro to import the snapshot text file,
I want an additional field with the date of import.

Fields:
Pers No
Start Date
End Date
Fraction
Name
Title
Gender
Import Date

Can anyone help me out with this?

Cheers

Pauline

 

[Peter Hill]

-----Original Message-----
Hi All

I download data from one computer system and import the
data into an Access database that is used for reporting
purposes.

The data is saved as a text file from the original system
and I run a macro to import the data to the database.

What I need to do is, when I import the text file I want
the table to show the date of import.

eg: Table - Snapshot

Fields:
Pers No
Start Date
End Date
Fraction
Name
Title
Gender

After running the macro to import the snapshot text file,
I want an additional field with the date of import.

Fields:
Pers No
Start Date
End Date
Fraction
Name
Title
Gender
Import Date

Can anyone help me out with this?

Cheers

Pauline
.

An easy (I think) way to do this would be to simply run a
make-table query adding the field "Import_Date: date()".
This means you don't have to alter any code that is
importing your text file in.

So - basically - the steps you'd follow would be:
1) Import your text file into a temp table.
2) Create a make-table query based on that temp table and
add the import_date: date() field
3) Delete the temp table

Peter

 

[Pauline]

-----Original Message-----


An easy (I think) way to do this would be to simply run a
make-table query adding the field "Import_Date: date()".
This means you don't have to alter any code that is
importing your text file in.

So - basically - the steps you'd follow would be:
1) Import your text file into a temp table.
2) Create a make-table query based on that temp table and
add the import_date: date() field
3) Delete the temp table

Peter
.

Thanks Peter

I think this will be useful to accomplish what I need.

Cheers

Pauline