finding reference from VBA script

[wilkob]

Probably not the best Title but I have a database where I import data and there seem to be some specs for the import (see below), but I cannot find those.

Private Sub Button1_Click()
Dim stDocName As String
DoCmd.SetWarnings False
stDocName = "Query1"
DoCmd.OpenQuery "Query1", acNormal, acEdit
DoCmd.TransferText A_IMPORTDELIM, "Sales History Import Spec", "Sales History", "c:\Data\salhis.txt"

I have looked everywhere but cannot seem to find it. Can anyone help me where I should look for the spec?? I looked in the modules part of the database but this is empty

 

[Bat17]

Not sure where it actualy stored, probably in one of the hidden system tables though.
If you do a manual import then you can select 'Advanced' in the wizard and this will let you load/save specs.

HTH

Peter

 

[wilkob]

thanks for the hint. I found the list of exsisting specs under the advanced button and were able to change the type of one of the fields