Re: Schema.ini for multi-row import?
- From: Mike L <mikel@xxxxxxxxxxxxxxxxxx>
- Date: Mon, 05 Jun 2006 12:01:52 GMT
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.
.
- Follow-Ups:
- Re: Schema.ini for multi-row import?
- From: John Nurick
- Re: Schema.ini for multi-row import?
- References:
- Schema.ini for multi-row import?
- From: Mike L
- Re: Schema.ini for multi-row import?
- From: John Nurick
- Schema.ini for multi-row import?
- Prev by Date: Re: 4577
- Next by Date: Re: Schema.ini for multi-row import?
- Previous by thread: Re: Schema.ini for multi-row import?
- Next by thread: Re: Schema.ini for multi-row import?
- Index(es):