Re: Is it possible to Change String Delimiter without using an interface Spec?

Hi Andi,

If you want to use TransferText the only way to specify a non-standard
delimiter is by using an import specification or a schema.ini file.

Probably the best thing to do is to include code in your routine to handle
it, e.g.
- create the appropriate schema.ini, then use TransferText, then delete the
schema.ini
or
- read the file a line at a time, parsing each line into fields and
appending the resulting record to the table


"Andibevan" <Andibevan@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:u$CNGAF5FHA.3136@xxxxxxxxxxxxxxxxxxxxxxx
> Hi All,
>
> I have build the following simple function to import data into a table but
> the data has a ' as the string delimiter. Is there any way I can specify
> the string delimiter without using an interface spec?
>
> I want to be able to distribute just the code on its own to keep it as
> simple as possible for the users.
>
> Thanks
>
> Andi
>
> Function fncBatchImport(strSRCpath As String, strTableName As String) As
> Boolean
> Dim strSRCdir As String, strSRCfile As String
> 'Reference the library Microsoft ActiveX Data Objects 2.1 (or higher).
> On Local Error GoTo ImportError
> 'DoCmd.Hourglass True
>
> DoCmd.TransferText acImportDelim, , strTableName, strSRCpath, True
> ImportEnd:
> 'DoCmd.Hourglass False
> fncBatchImport = tableExists(strTableName)
> Exit Function
>
> ImportError:
> MsgBox Err.Description
> ' DoCmd.Hourglass False
> End Function
>
>


.

Relevant Pages

  • Re: regex/preg_replace? How do I do this?
    ... input source, you may also need to specify the delimiter at the ... What I need to do is to find all instances in a string where there are ...
    (comp.lang.php)
  • Re: Is it possible to Change String Delimiter without using an interface Spec?
    ... >> Hi Andi, ... >> If you want to use TransferText the only way to specify a non-standard ... >>> Function fncBatchImport(strSRCpath As String, ...
    (microsoft.public.access.externaldata)
  • Re: string manipulation function
    ... Recent versions of Access have a Splitfunction that allows you to specify ... In older versions, use Instr() to locate the delimiter, and Midto chop up ... > Is there a function allowing me to cut a string of characters separated by ...
    (microsoft.public.access.modulesdaovba)
  • Re: Importing from CSV file
    ... Yes, that imports each row as one long string, even when I ... specify the delimiter ...
    (comp.soft-sys.matlab)
  • Re: Programmers unpaid overtime.
    ... tokenizing a string correctly. ... ability to specify a set of delimiter tokens, ... >> postmodern attack on language itself, ... An the scientists, in turn, think a lot of that artistic talk about ...
    (comp.programming)