Re: Importing from CSV file



"Jannie Roux" <JannieRoux@xxxxxxxxxxxxx> wrote in message
<fq0v1v$ctl$1@xxxxxxxxxxxxxxxxxx>...
Have you tried importdata functione yet?

Yes, that imports each row as one long string, even when I
specify the delimiter
.



Relevant Pages

  • Re: Is it possible to Change String Delimiter without using an interface Spec?
    ... 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. ... > the data has a ' as the string delimiter. ...
    (microsoft.public.access.externaldata)
  • 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: 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 text, etc. on remote .mdb file
    ... You can then use VBA string functions to get from there to the ... Is there an easy way to schedule the imports of the text files so I ... 'Modify strSQL and filenames as required ... Dim oJet 'DAO.DBEngine ...
    (microsoft.public.access.externaldata)
  • RE: Logon Error
    ... > Imports CrystalDecisions.CrystalReports ... > function is emailPDFwhich calls ChangeLogOnInfo EmailPDF returns a Report ... > Dim szErrorMailSecondary As String 'This is where all the mail messages ...
    (microsoft.public.dotnet.framework.aspnet)

Loading