Text Import Specs

[orcinus]

Using Access 2003

I would like to change the name of an import specification I created. I don't want to change any of the details, just simply, the name.

Any help on how to do this is appreciated..

[NTC]

mmm....well if nothing else...start a manual import, during that select the 'Advance' in the lower right....and then select your Spec which will be listed there....and then you have the object to 'Save As'

this doesn't really change the name, but it makes a duplicate with whatever name you want....which hopefully is sufficient....

[maximus]

strTableName = "Sans_" & Me.Text5
strFilePath = Me.Combo13 & Me.Text11 & Me.Text15 & ".txt"
DoCmd.TransferText acImportDelim, , strTableName, strFilePath


In this Example I have use a Collection of form objects to specify the name of the file to be imported.

You can use a Text Box to refer to the file you need to import.

Note: here the file name generate with complete path reference like 'C:\MainFrame.txt'

[orcinus]

mmm....well if nothing else...start a manual import, during that select the 'Advance' in the lower right....and then select your Spec which will be listed there....and then you have the object to 'Save As'

this doesn't really change the name, but it makes a duplicate with whatever name you want....which hopefully is sufficient....

Trying to avoid that, but thanks!