Re: Fix transfer text automation

Hi,
i think you have to make a new import specification, and for other layouts
use it

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Ray Mead" <RayMead@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BF244709-9C05-4932-8FB7-10D142E15640@xxxxxxxxxxxxxxxx
> Help! Below is the code to automatically import all text files. This
> code
> works great if the files are in the same layout, but causes data shifting
> if
> the fields change. How do I modify the code to change it to update if the
> file layout is different?
>
> If varX = "text" Then
>
> varH = Me.cboImportFileSelect
> varI = Me.cboImportFileSelect.Column(1)
> varJ = Me.cboImportFileSelect.Column(2)
> varK = Me.cboImportFileSelect.Column(3)
> varM = Me.List11
>
> DoCmd.TransferText acImportDelim, varM, varH, varJ & varK, True, ""
>
> Call AddSource(varH, "Source")
> Call AddFileName(varH, "SourceDatabase")
> Call AddCounter(varH, "ConversionID")
>
> MsgBox "update complete"
> End If


.

Relevant Pages

  • Re: Fix transfer text automation
    ... But I was hoping to modify the existing code. ... "Alex Dybenko" wrote: ... >> works great if the files are in the same layout, ... >> the fields change. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Fix transfer text automation
    ... Is there a way to reset the import wizard query as listed in the me.list11? ... But I was hoping to modify the existing code. ... >>> works great if the files are in the same layout, ... >>> the fields change. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Not seeing Indent options when I place my cursor on the ruler
    ... no tips display, but the did display in Print Layout. ... [MVP] ... it says another kind of indent which I forget. ...
    (microsoft.public.word.docmanagement)
  • Re: Change Default View to Normal?
    ... Change the vertical layout from Center to Top, ... Word MVP FAQ site: http://word.mvps.org ... >> Suzanne S. Barnhill wrote: ...
    (microsoft.public.word.newusers)
  • Re: PRINTING TOO LOW IN WORD
    ... Word MVP FAQ site: http://word.mvps.org ... Something happens between the layout ... >> are using the same sized paper settings and you don't have a header in ...
    (microsoft.public.word.pagelayout)
Loading