Re: Fix transfer text automation

Is there a way to reset the import wizard query as listed in the me.list11?
I think the field names are somehow cached. If we can clear those, then I
should be home free....

I think the specs list is maintained in table MSysIMEXSpecs

"Ray Mead" wrote:

> That is an option. But I was hoping to modify the existing code. I'm sure
> there is somekind of refresh or requery to use. If I close the form and
> reopen it, the program will import the file with the new specification.
>
> I choose the import specification from a list, me.list11. Is there away to
> clear the import specification at the very end so when it loops, it starts
> out clean?
>
> "Alex Dybenko" wrote:
>
> > 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
Loading