how to use a different record delimiter ?

  • Thread starter Thread starter jisha.abubaker
  • Start date Start date
J

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
 
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.
 
Back
Top