Access to XFDF

  • Thread starter Thread starter chris48178
  • Start date Start date
C

chris48178

Hello all, first time poster, hope you can help...

I have an MS Access 2002 Database with 1 Table and 650+ Records.

Ultimately, I would like a PDF document organized with data from the
database.

I already have the PDF form with the appropriate fields, and have
tested a sample XFDF file.

What I need to do now is get each record of the DB to export, or be
extracted somehow to individual XFDF files in the following format:

<?xml version="1.0"?>
<xfdf xmlns="http://ns.adobe.com/xfdf/" xml:space="preserve">
__<fields>
____<field name="-FIELD1-">
______<value>-VALUE OF DB CELL 1-</value>
____</field>
____<field name="-FIELD2-">
______<value>-VALUE OF DB CELL 2-</value>
____</field>
____<field name="-FIELD3-">
______<value>-VALUE OF DB CELL 3-</value>
____</field>
__</fields>
<f href="-LOCATION_OF_PDF_FORM-.pdf"/>
</xfdf>

Also, I would like the file name to be derived from the contents of one
of the fileds (i.e. -VALUE OF DB CELL 1-.xfdf).

I am fairly new to Access, and do not have much coding/scripting
experience.
 
I would use the microsoft scripting runtime library that creates a
textstream( the contents of a text file) and the ADO recordset object to
iterate thru each record to create the XFDF file. look in the online help
for these libraries after referencing them through the tools, reference
menu.
If this is over your head I can help you with code samples.
HTH
 
Just wanted to update....

I created an ODBC connection to my DB.
Then used a PHP script to generate the files.
 
Back
Top