Re: Fix transfer text automation

Not quite understand what you need, but yes, you can modify import
specifications table MSysIMEXSpecs, you have to open a query based on this
table in order to make it editable

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


"Ray Mead" <RayMead@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2B73A347-E45B-4293-9876-3EACB733FB1B@xxxxxxxxxxxxxxxx
> 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

  • Re: Step through each field in query
    ... But I want to modify it so that I can use this one query to step through each ... of the given fields and append them to the final report as opposed to having ... John W. Vinson [MVP] ...
    (microsoft.public.access.queries)
  • Re: Programmatically changing the field formats for a table
    ... You can modify some properties of a field with SQL statements, ... Roger dot Carlson at Spectrum-Health dot Org ... > created using a query. ... > the resulting table does not keep the field formats of the ...
    (microsoft.public.access.tablesdbdesign)
  • Re: webbased search through catalog
    ... I've got the asp script working, but it seems to spit out results ... Modify q.catalog to specify your catalog name. ... > ' your logo is not a GIF file, or you don't want to copy it, change the ... > ' You can set the number of query results returned on a single page ...
    (microsoft.public.inetserver.indexserver)
  • Re: Modify an error in linking to a text file
    ... Access creates an import/export specification for itself even if you ... Click the Specs... ... you can see how the specifications are stored in MSysIMEXSpecs and ... It is not possible to modify the data type in Table/Design, ...
    (microsoft.public.access.externaldata)
  • Re: Changing query at runtime
    ... Thanks Joan, I already tried that, but after giving the qtemp object Read ... Design, Modify Design and even Admin permissions, I still get the "You do ... option" clause in the query. ... and give users modify permissions to the query. ...
    (microsoft.public.access.security)