how to use a different record delimiter ?

[jisha.abubaker]

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]

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.