how to use a different record delimiter ?

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

.

Relevant Pages

  • Re: XL2003 open .CSV problem
    ... and recorded as a macro it gave a very long list of statements instead of one ... The funny thing is that opening the .csv file manually gives the expected ... and I had a macro opening a .CSV file: ... columns (I use a Hungarian version where list separator is semicolon). ...
    (microsoft.public.excel.programming)
  • Re: auto append to table from a csv file
    ... VBA code would be more robust than a macro (since macros don't allow for any ... You could use a form's Timer event: set it to check for a new file every 10 ... > use Access to append the infromation in the csv file to a table. ...
    (microsoft.public.access.devtoolkits)
  • auto append to table from a csv file
    ... I have an application that update a CSV file every 10 minutes. ... use Access to append the infromation in the csv file to a table. ... I have created a macro I can execute to retrieve the csv data and append it ...
    (microsoft.public.access.devtoolkits)
  • Need Help With Export Code
    ... Below is some code I wish to use to export a "modified" csv file. ... By "modified" I mean that the csv file uses a semicolon; ... Dim FName As String ... Set ftext = fs.CreateTextFile ...
    (microsoft.public.excel.programming)
  • Re: List Separator
    ... Excel follow the delimiter specified as the List Separator in the ... Not loading correctly means the delimiter is being ignored. ... confirms that Excel believes the delimiter to be a semicolon! ... very short csv file in note pad. ...
    (microsoft.public.excel.programming)