Re: Schema.ini for multi-row import?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Mike,

As far as I know there's no way of getting the text file driver to use
FF - Chr(12) - as the record separator: it assumes you want to use CR+LF
- Chr(13) & Chr(10).

So I think your choices are

1) write VBA code that opens a recordset, assembles records and writes
them to disk; or

2) use an Access report and export it to a text file. If you make sure
that all vertical dimensions in the report are multiples of 0.25 inches,
and format all the text in 12 point Courier New or other monospaced font
things should work OK. Sometimes it helps to install the Windows
Generic/Text Only printer driver and use that for the report.

On Fri, 02 Jun 2006 17:13:26 GMT, Mike L <michaellazenby@xxxxxxxxxxx>
wrote:

I've got some data which is basically just an outputted report. I need to
create one record out of a file that is like

NAME ACCOUNT

ADDRESS1 ADDRESS2
<JUNK> PHONE

etc.etc.

Each record is the exact same layout and separated by a page break. I know
if each record was on one line the schema.ini would be pretty easy to make.
Can a multi-row schema.ini file be set up?

Thanks.

Mike L.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

Relevant Pages

  • Re: Question about VBA in the report
    ... I have a report that is based on a query, but I want to use VBA code ... You can't reference a property or method for a control unless the ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.reports)
  • Re: Inserting an Access 2000 report into a Word document
    ... use DoCmd.OutputTo to print the report to an RTF ... Microsoft Access MVP ... I just need the VBA code to insert ...
    (microsoft.public.access.formscoding)
  • RE: Comparison Report based on a query of only calculations.
    ... Dave Hargis, Microsoft Access MVP ... "Amy Schmid" wrote: ... Client number Client Name Avg # of Cows Production Livestock ... And you want them to appear on the report like: ...
    (microsoft.public.access.reports)
  • Re: In a report -Using a calculated field in Select Case causes Er
    ... Dave Hargis, Microsoft Access MVP ... "Maverick" wrote: ... should open on its own and suspend execution of the report. ... The line has not executed, but it will be the next to execute. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Report parameters
    ... Microsoft Access MVP ... and you'll never work a day in your life." ... and make sure you use cboEmpID value in your Open Report ...
    (microsoft.public.access.reports)