Can you programmatically change Spec File in Access Import wizard 1

[SBendBuckeye]

If I manually walk through importing a comma delimited file into Access, I can modify field attributes via the wizard and optionally save them for future use. Are those files exposed anywhere in Access? The number of columns in the input files varies and I would like to tailor it to the input file.

Thanks for any help or suggestions!

Have a great day!

 

[Nikita6003]

I think it's possible to save the specs for any TextImport to a file (when using the wizard click ANDVANCED button - then click Save As in the next window. File is stored ).
If you create one for every .csv permutation you might get, you can use each schema (info is stored in the schema.ini file). Use TransferText with the Specification name parameter to set the Specs you need for any particular import

this link might be helful:
For Office97 use

http://msdn.microsoft.com/library/d.../en-us/office97/html/workingwithtextfiles.asp

For Office 2000 use

http://msdn.microsoft.com/library/d...ff2000/html/achowImportDelimitedTextFileS.asp

HTH

Cheers
Nikki

 

[SBendBuckeye]

Great stuff Nikki, sorry I can only give you one star. I had manually done all of the stuff mentioned but couldn't find where Access tucked it away at. I looked everywhere I could think of to find that. How did you know to look where you did (without revealing any trade secrets of course ;-)?

Have a great day!

 

[Nikita6003]

By accident - I used to teach this stuff to Support ppl & they came up with the WEIRDEST questions.
This just happens to be one of them ;-)

Cheers
Nikki

ps - ta for the star (tho' undeserved)