Access to XFDF

[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.

 

[William Taylor]

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

 

[chris48178]

Just wanted to update....

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