Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can Import/Export Specifications be viewed & edited without a wizard? 2

Status
Not open for further replies.
novena

novena

MIS
Nov 26, 2003
8
US
Is there a way to view and manipulate the Import/Export Specifications in an Access DB without going through either the Import Wizard or the Export Wizard? Alternately, is there a way to dump those specs directly into a schema.ini file (or even a plain-text file)?

Now that I know how they work, I'd rather use schema files than I/O Specs, but it seems like a pain to re-create schema files field-by-field when I already have I/O Specs set up.
 
Sort by date Sort by votes
This information is stored in a couple hidden system tables
MSysIMEXSpecs and MSysIMEXColumns. For instance, you can use the following SQL to view some of the information.

SELECT MSysIMEXSpecs.SpecID, MSysIMEXSpecs.SpecName, MSysIMEXColumns.FieldName, MSysIMEXColumns.DataType, MSysIMEXColumns.IndexType, MSysIMEXColumns.SkipColumn, MSysIMEXColumns.Start, MSysIMEXColumns.Width
FROM MSysIMEXSpecs INNER JOIN MSysIMEXColumns ON MSysIMEXSpecs.SpecID = MSysIMEXColumns.SpecID;

I believe you can modify the records using code with recordsets.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Upvote 0 Downvote
Thanks, that's just what I needed.

- Jeremy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
634
TheresAlwaysAWay
TheresAlwaysAWay
grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
858
grnzbra
grnzbra
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
649
TheresAlwaysAWay
TheresAlwaysAWay
ameedoo3000
  • Question
switch between two open database
Replies
12
Views
535
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
306
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top