Import specifications?

[Guest]

There are these.....these THINGS called "Import Specifications" attached to tables. I can't find any way to access them for editing or otherwise. In fact, the only way to "interact" with them seems to be during the table-import process, where I can select "Options" and then check a box to indicate whether or not to include import specifications with the table. The problem is, when I tried to import such a table, there was a conflict with some index names. How do I get at these elusive, seldom-mentioned "Import Specification" creatures? I have to deal with them because of existing code and processes, otherwise I wouldn't even know they existed.

Thanks!

 

[Adrian Jansen]

Yes, they are a bit hidden. But if you check the box "Use import
specification" and ask for a spec by name it sets up the import according to
that. You can then step through the various dialogs, and change any
settings you want, then do the import, and also save or not the new settings
back to a spec.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

There are these.....these THINGS called "Import Specifications" attached

to tables. I can't find any way to access them for editing or otherwise.
In fact, the only way to "interact" with them seems to be during the
table-import process, where I can select "Options" and then check a box to
indicate whether or not to include import specifications with the table.
The problem is, when I tried to import such a table, there was a conflict
with some index names. How do I get at these elusive, seldom-mentioned
"Import Specification" creatures? I have to deal with them because of
existing code and processes, otherwise I wouldn't even know they existed.

 

[Adrian Jansen]

You need the import wizard to get to that, and set up a specification. I
thought that wizard was installed as standard with Access, but it may be an
option. Once you have the specification stored, you can use the
TransferText method in code to import the data. In fact the Help for
TransferText refers to a schema.ini file, which appears to be a text file
containing the import spec. Maybe you can manipulate that to do what you
want.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

Is that check box only available through the wizard? My machine is

currently "wizardless", so if you've any other suggestions, they would be
most appreciated. In the meantime, I'll see if I can follow the yellow
brick road...