Import date and time 1

[ptrifile]

I have an excel spreadsheet that I import into a table every 4 hours, what i would like to do is have the time and date that the file is imported...is there a way to write this to a table so i can run reports on how many new orders were imported into my system between certain times?

Thank you for any help!

Paul

 

[Remou]

You could use a query, for example:

INSERT INTO tblT ( [Id], [Blah], [ImportDate] )
SELECT Id, Blah, Now As ImportDate
FROM [Sheet1$] IN '' [Excel 8.0;database=C:\Docs\LTD.xls];

 

[ptrifile]

Thanks Remou, if I'm reading this correctly this would pull the import date from a field or row or cell from excel, right?

If so, is there a way to do it if the import date is not in the spreadsheet? so just have it automatically give the exact time and date it was imported into access?

Thanks again!

Paul

 

[Remou]

You will notice the SQL includes:

Now As ImportDate

This should put the current date and time into a field.

 

[GingerR]

Now() is an MS Access built-in function, it returns the date and time.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[ptrifile]

Remou, Thank you! I missed the NOW in the code. Thank you for your help, that worked perfectly!

Paul

 

[PWise]

set the default value of importdate field in the table to now()