Re: Schema.ini for multi-row import?

Tech-Archive recommends: Fix windows errors by optimizing your registry



Any chance you could post a snippet of code showing read line 1 10 chars to
Field 1, read line 2 10 chars to Field 2 to then next rec on FF? I should
be able to extrapolate from that. I'm not a programmer, just a poor O/S
guy!

Mikel@xxxxxxxxxxxxxxxxxx

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


Mike L.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.


.