Re: how to use a different record delimiter ?
- From: John Nurick <j.mapSoN.nurick@xxxxxxxxxxxxxx>
- Date: Tue, 21 Mar 2006 22:46:01 +0000
Hi Jisha,
Access's import routines require the two characters CR LF as record
separators; you can't change this.
What I'd do is write code to pre-process the file (changing ; to CRLF)
and then import it.
On 20 Mar 2006 10:04:53 -0800, jisha.abubaker@xxxxxxxxx wrote:
Hi
I am trying to build a macro that can automatically import and then
append the data in a CSV file to an existing table.
The fields within the record are comma separated but the records are
separated by a semicolon and not a new line.
Is there a way I can change the default newline record delimiter to a
semicolon ?
Thanks in advance
Jisha
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
.
- References:
- how to use a different record delimiter ?
- From: jisha . abubaker
- how to use a different record delimiter ?
- Prev by Date: Size INCREASE when Importing FoxPro via ODBC ???
- Next by Date: Re: Export Report to ASCII Creates Creeping Pages When Printed
- Previous by thread: how to use a different record delimiter ?
- Next by thread: schema.ini files
- Index(es):
Relevant Pages
|
