Paradox Text Based Reporting and Access

My office uses Paradox for its text-based reporting abilities. We wrap style tags around different fields to create mark-up text to importing into InDesign for a publication we work on.

At the bottom of this post is a sample of the plaintext report we export out of Paradox. Basically it is a style tag <EXAMPLEStyle> followed by data from an database record with a paragraph break after it. The style tags are literals in the report. The data that files the tag is being pulled from the database.

I was wondering if there was a relatively straight forward way to do something like this in Access. We're migrating to Access 2013 from Access 2007 and are unable to export to the Paradox file format with Access 2013. We want to completely remove Paradox from our workflow anyway, it is a crutch that has served us well over the years but we're ready to move on.

I will answer questions anyone has if additional info is needed or I haven't made myself clear.

<DRGCo>Antrim
<DRGTwp>Mancelona, T29N, R5W
<DRGSymb>n
<DRGOpr>   Atlas Resources, LLC!   State Mancelona*1-28 HD1
<DRGSL>(W) SL: Sec 28 NW NE NW P# 60271 (TRN-12175')
<DRG12>BHL: Sec 28 SW SE SW
<DRG15>unit--E SW/E NW  (BHL: 465 S/1968 W - Sec)
<DRGSymb>n
<DRGOpr>   Chevron Michigan LLC!   State Mancelona*1-31
<DRGSL>(W) SL: Sec 31 SW SW SE P# 60169 (TRN-8100')
<DRG12>unit--W SE  (330 S/2002 E - Sec)
<DRGSymb>q
<DRGOpr>   Merit Energy Co.!   State Mancelona*8-33
<DRGSL>(W) SL: Sec 33 SW SE SW AP 20110068 (CLG-8100')
<DRG12>BHL: Sec 33 NE NE NW
<DRG15>unit--E W  (BHL: 515 N/1982 W - Sec)
<DRGCo>Barry
<DRGTwp>Johnstown, T1N, R8W
<DRGSymb>n
<DRGOpr>   Arbor Operating LLC!   Swanson*4-7
<DRGSL>(F) SL: Sec 7 NE SW SW P# 60402 (TRL-1975')
<DRG12>unit--SW SW  (988 S/983 W - Sec)
<DRGAct>   td!   td 6/10/2012
<DRGCtr>Advanced Energy Ser. 10, cont.
<DRGSymb>n
<DRGOpr>   Wolverine Gas and Oil Company of Michiga!   Halbert*D3-7
<DRGSL>(F) SL: Sec 7 NE SW SE P# 60438 (TRL-2000')
<DRG12>unit--SW SE  (937 S/1801 E - Sec)

 

Question Info


Last updated February 12, 2018 Views 62 Applies to:

You could create a report, embedding your tags, then export the report to a text files with a command like this.

 

DoCmd.OutputTo acOutputReport, "Reportname", acFormatTXT, "full filename.txt"", False

Jack Stockton
Microsoft Access MVP 2012 - 2017

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I guess exporting it isn't the part I'm having trouble with, it is setting up a report exactly to read so that each entry is grouped by County and Township, and getting the literals in there as well. I'm pretty new to Access and I'm not really sure how to set up a query or report to get it to output the data like in the example.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Looks like your data is nothing more that a lable, so try this.

  1. Start by creating a query that has the minumum number a columns that you need...do not set a sort, the report can do that.
  2. Select the query, then from the ribbon click Create/Labels
  3. Select a Continuous 1 across label like the 4160, click Next
  4. Click Next for the Font setting, we don't care.
  5. Enter a tag, such as <DRGCo>, then bring the field across withthe > button, press enter for new line.
  6. Enter next tab and bring the field across and press enter until all rows are created.
  7. Click Next to continue
  8. Bring the fields across to sort by, then Click Next
  9. Enter a name for the Label report and click Finish.

If you go into Design View, you can get rid of all the empty space (resizing the report.)

If you have rows that should not print if there is no data, edit that rows Data source and use an IIF to evaluate and if empty display "".  i.e. =IIF(Len([DRGCo]), <DRGCo>[DRGCo],"")

 

Once it looks like the report displays all the data, try the export. 

Jack Stockton
Microsoft Access MVP 2012 - 2017

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.