RE: Automatically Import when a file is modified

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thank you very much for the reply. I did try that and didn't have much luck.

I have the job scheduled to run every night on our mainframe. The job
"allows" me to request my own file name. So, I thought that if I just named
the file Open.tab (as opposed to .xls) I could create a spec and use the
trasfertext command. The problem that I came across is that even though the
job that I scheduled appears to let me choose my file name and extension,
when I put in Open.tab for the output file name the file does not get
created. The file is only created if I instruct our mainframe to create a
file with a .xls extension.

I am not too worried about changing the file name to a true Excel file. I
have no idea how to code my DB to recognize when a file is modified to import
and then run the rest of the routine I have coded. I thought I saw in some
other posts (that are way over my head) that it was possible.

If I can get the file to import automatically, then ideally the end result
would be my final results being e-mailed to recipients.

I am completely self taught, so I apologize if I don't use correct
termnology or if this is an inappropriate question. I have tried looking at
online help and didn't see much, so please don't think I am not putting my
own effort into this, I really have. I just don't have the training or
experience that I desperately need and want. :o(

Thanks,
Roger

"Klatuu" wrote:

If it is actually a tab delimited text file, have you tried using
TransferText instead of TransferSpread***.
Go through the import process once manually and set up an import spec for it.
Then you can bypass the reformatting part.
--
Dave Hargis, Microsoft Access MVP


"Roger Converse" wrote:

Here is my issue...

I have a file that gets kicked off our mainframe nightly. The file is
requested as an Excel file. Although when kicked off, the file appears to be
in Excel format and ends with a .xls extension, the file is really a teb
delimmetted file. Therefore, every morning I come in and save it as a "true"
.xls file and then import to my database via a form.

I think I can create a macro in Excel that will resave the file as an .xls
file automatically each night.

Here would be the ideal process:

- 3:10 a.m. every night, file is sent from mainframe to F:/ drive.
- macro runs that changes the file type to .xls
- Access DB imports file and then I can set the rest of the code to run in
the "import" event for this file.

Where I think it gets tricky, is there will be two modifications of the file
every night, and I only want to import after the second modification. I
suppose I could create the Excel Macro to automatically change the file to a
.tab extension. I guess then t 3:10 an filename.xls will have a new modified
date and then after the macro the filename.tab will have a new modified date
and on the change in modified date for filename.tab would trigger the import.
Is this sound reasoning?


.

Quantcast