Convert text files to PDF

  • Thread starter Thread starter Jeff C
  • Start date Start date
J

Jeff C

I use Stephen Lebans Snpshot To PDF extensively in Access 2003 and also have
Adobe 5 with Distiller and PDF Maker.

I have approx 150 reports that drop as ASCHii txt each month that need to be
converted and saved with the same filename to PDF files. Leban's program
nicely removes the exercise of manually entering a new file name and location
when converting to PDF files. The files are being converted and saved as
part of ongoing audit/backup requirements.

Is there any chance that Access could be the engine driving a batch convert
process for this? I have been scouring google searches for command lines
with Adobe and/or WORD to try and come up with a solution but have had no
luck. I primarily live in Access anyway (why not???) . . . any pointers to a
solution would be very much appreciates.

Thanks in advance
 
Hi,
you can "load" text files into Access report and then convert it to PDF, do
not see any problem here. Just read text into string var, then you can put
in in temp table with one field and make access report on this table

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
--
Jeff C
Live Well .. Be Happy In All You Do


Alex Dybenko said:
Hi,
you can "load" text files into Access report and then convert it to PDF, do
not see any problem here.
Click to expand...

Just read text into string var, then you can put
in in temp table with one field and make access report on this table
Click to expand...

Hmm, that's interesting - some of the reports are 500+ pages of financial data

Thanks Alex
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
Click to expand...
 
I use Stephen Lebans Snpshot To PDF extensively in Access 2003 and also have
Adobe 5 with Distiller and PDF Maker.

I have approx 150 reports that drop as ASCHii txt each month that need tobe
converted and saved with the same filename to PDF files.  Leban's program
nicely removes the exercise of manually entering a new file name and location
when converting to PDF files.  The files are being converted and saved as
part of ongoing audit/backup requirements.

Is there any chance that Access could be the engine driving a batch convert
process for this?  I have been scouring google searches for command lines
with Adobe and/or WORD to try and come up with a solution but have had no
luck.  I primarily live in Access anyway (why not???) . . . any pointers to a
solution would be very much appreciates.

Thanks in advance
Click to expand...

Can you start one of those converters from the command line (DOS) ?
Access could write a batch file of command lines and then SHELL out to
execute it.

Hope this helps,
Chris M.
 
--
Jeff C
Live Well .. Be Happy In All You Do


mcescher said:
Can you start one of those converters from the command line (DOS) ?
Access could write a batch file of command lines and then SHELL out to
execute it.
Click to expand...

Thanks for that idea, I continue to search for the command line to
accomplish this, running the a series by shelling out from access is a great
idea.

Alex's idea is good also but I am afraid the size of the files won't work
with it.
 
Back
Top