Import Specification

[BlindPete]

Do I have to use the Access UI to build, save and modify my import specification.

I have to create several dozen of them and they will be changing over time. I'd much rather just create the specification in VB and modify them as needed.

Am I dreaming?

Where in the Access object model are the specifications stored?

-Pete

 

[Remou]

It is possible to meddle with the system tables MSysIMEXSpecs and MSysIMEXColumns, with the usual warnings

 

[barny2006]

remou,
i have a question. when i select * from MSysIMEXSpecs, what fields are there to retrieve (i.e. fielditems)?

 

[Remou]

barny2006
Why not iterate through the fields collection or look at the table design? What is your point?

 

[BlindPete]

Hi Barny2006, thanks for hi-jacking my thread. :-(

Remou,
thanks for the response. I don't want meddle with them, I thought may be there were ways to create and modify them with VBA native to Access's Object model.

I'm surprised (and disappointed) that MS buries it so deep. I would think the ability to create and manipulate these specifications on the fly would be a desirable feature.

-Pete

 

[barny2006]

blindpete,
no such intentions. i'm just merely learning, as all of us do. i read threats to learn. and sometimes come across solutions, points that i face at my work. that's all.

 

[BlindPete]

no worries Barny, it is not like i have not done it too! ;-)

-Pete

 

[barny2006]

remou,
i mean, as pete said, if i want to retrieve and save import specs in a file or something, how could i iterate through the msysimexspecs? can i do a select from msysimexspecs? and if i do, what fields/columns are in that object? can you give an example?
like this one?
SELECT MSysObjects.Name FROM MsysObjects " & _
"ORDER BY MSysObjects.Name;"
this will list all the objects' names, tables, queries, reports, modules, forms, etc. one of which is msysimexspecs. then i use this code to list the name of the object:
obj_name = objRecordset.Fields.Item("name")
which lists the name of objects.
in case of msysimexspecs, what field items are available?

 

[Remou]

barny2006
I think we have tried BlindPete's patience far enough. Please start a new thread before we become guilty of spamming!