Hola senor en senora.

I have a question about calling Access macros in ASP page. I already have done the codes to call the method from Access. I go back to the database & see that the data has been successfully been imported.

Actually, I thought of creating by scratch my own database, with table, with macro & see if I can import using the ASP codes.

First, I created a DB & I copied a table's field columns into the table created in the new DB. Then, I created a macro. Then I specify the Import Specification name to the macro.

In all my text files has this header:
Eg.
ITXNRPT ERP INVALID TRANSACTIONS REPORT BY TERMINAL PROC DATE : 02/02/2005 PAGE : 1 PROC TIME : 02:18:42

And hence, all my tables has this field column called reportDate. And these text files does not have any data for reportDate. So, I need to make it such that everytime importing data is being done, the reportDate is able to record the day of the import minus 1. That means Access displays the date as 1 day before.

I only know how to define the day as current Now()-1. But I am not sure on how to display the date as 1 day before.

And also, I was thinking about prompting the User to enter input for reportDate just in case if the data to be imported was a back-dated text file (meaning that for a particular text file, for some reason, it did not import the data for that day & then the next data came bla bla..) & then I need to prompt the User to specify the date the data being imported manually by the User.

Is all that possible?? I don't really know where to continue from where I'm stuck. Do hope I could clarify my doubts & questions here. Gracias.

you cannot use the Access macros directly, but if you can recode them as stored procedures then you can call them.
Or rewrite the macros as ASP code

Hola Senor. Can you please explain that in detail?

Why should we create a stored procedure? And how do I start? Could you give me some pointers? Gracias Senor.