specification name

[Stephanie]

Hi. I'm using a db that someone else designed and I'm trying to find and
change the sepcification name file. This is the code:

'Import new data...
DoCmd.TransferText acImportDelim, "NewIRSSpecification", "tbIncidents_OLD",
"Z:\MY DOCUMENTS\IRS_OLD.csv", True

But I can't find "NewIRSSpecification" file. I see an old, unused macro as
wll that has this file as a pull down so it must be out there.

I'd appreciate your guidance.
Cheers,
Stephanie

 

[Ken Snell [MVP]]

Easiest way to change the specification NewIRSSpecification is to begin to
do the import manually (File | Get External Data | Import) and select the
file you want to import. Then, in the Wizard window, click the Advanced
button at bottom left of window. Click the Specs... button and select the
specification that you want to change, and click Open. Then you can modify
the spec's info in the window. Then click Save As... button and select the
same specification name that you opened, and your changes will be saved for
that specification. Then click OK button. In the Wizard window, click
Cancel.

 

[Stephanie]

Apologies if this is a duplicate post-

Thanks Ken.
My excel file is a .csv but the "get external data" dialog only allows me to
browse .xls files. Thoughts?

Cheers,
Stephanie

 

[Ken Snell [MVP]]

When the browse to file dialog window opens, do you not see a dropdown list
for file types (extensions)? Scroll down that list and you'll see a single
entry for .txt, .csv, .dat files.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/