Convert text files to PDF

[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

 

[Alex Dybenko]

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]

--
Jeff C
Live Well .. Be Happy In All You Do

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

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

 

[mcescher]

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

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]

--
Jeff C
Live Well .. Be Happy In All You Do

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.

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.