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.
<DRGTwp>Mancelona, T29N, R5W
<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)
<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)
<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)
<DRGTwp>Johnstown, T1N, R8W
<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.
<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)
This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.
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.