Import/Export Specification

[Guest]

In Access 2.0 I was able to select from the menu bar to display all the
specification I had.
Now I have to select Import or export, select a file, and then go to
advance to see all the specification.
Do I miss anything and there is a better way to do that or this is the only
way to get the specification now, and if so, why Microsoft made that decision
to remove this option from the menu bar.

 

[roadie.girl]

what are you trying to view? just how to export a table? i'm thinking
you're running into the fact that in newer versions of MS Access, the
menues change. why did MS remove the decision from the menu bar? not
quite sure what you're talking about ..which menu bar that is. but
programmers chang things for various reasons - probably was more
aesthetic the way it is now. not many people utilize the 'advanced'
options, so they wanted to allow the advanced user to still have those
options, but not confuse novice users wtih all of them. upgrades don't
always agree with all customers...

 

[Guest]

I'll try to make more sense.

In my application I run alot of import and export to and from Text files,
for each file there is a spec defined, for the structure of the file.
In Access 2.0, there was an option to select from the menu File > Specs, and
that gave me the list of all the specification.
Now, this option was removed, and I have to do a long way just to view the
specs. I'm wondering if I'm wrong, and there is an easier way.

Thanks

 

[Roger Carlson]

Nope, your not wrong. That's the way you have to do it currently. I'm not
sure why they changed it.

However, if you just want to VIEW them (not EDIT them), you can do so with
the following query:

SELECT MSysIMEXSpecs.SpecID, MSysIMEXSpecs.SpecName,
MSysIMEXSpecs.DateDelim, MSysIMEXSpecs.DateFourDigitYear,
MSysIMEXSpecs.DateLeadingZeros, MSysIMEXSpecs.DateOrder,
MSysIMEXSpecs.DecimalPoint, MSysIMEXSpecs.FieldSeparator,
MSysIMEXSpecs.FileType, MSysIMEXSpecs.SpecType, MSysIMEXSpecs.StartRow,
MSysIMEXSpecs.TextDelim, MSysIMEXSpecs.TimeDelim, MSysIMEXColumns.FieldName,
MSysIMEXColumns.IndexType, MSysIMEXColumns.SkipColumn,
MSysIMEXColumns.Start, MSysIMEXColumns.Width
FROM MSysIMEXColumns INNER JOIN MSysIMEXSpecs ON MSysIMEXColumns.SpecID =
MSysIMEXSpecs.SpecID;

Another alternative is to create a Form/Subform with MSysIMEXSpecs as the
RecordSource for the Main Form and MSysIMEXColumns as the RecordSource for
the SubForm. You can see these System files by going to Tools > Options and
checking System Objects. Once your done making the form, you can uncheck it
and the form will still work.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Thanks, I appriciate your help