Importing from Excel and Set a date value

[Mreid99]

I have a need to import data from an excel spreadsheet. This data contains ten fields and is imported to a table with 17 fields of which a download date is a field. I would like to auto populate the download date field with the date it was downloaded into the table.

 

[smedvid]

Why not use an Update SQL statement. You can use a Where clause of where data is null...<br>
<br>
htwh,<br>
Steve<br>

 

[Lehtoant]

Hi,<br>
<br>
Import Excel-sheet first to temporary table. Then make insert query from temporary table to target table where you match all the matching fields plus make an extra expression field with Date() function and match that to target table's download date field. And make these steps (import, insert, delete rows from temp.table) as a nice macro.<br>
<br>
This can sometimes be faster than UPDATEs.<br>
<br>
Yours,<br>
Al

 

[Mreid99]

Thanx for the replies, that worked..