Editing Import/Export Specifications

[Dean H.]

I import a lot of text files and have set up several
import/export specifications using the import text wizard.
Is there any way I can edit these specifications without
always opening the import text wizard? I am using Access
97. Any help would be appreciated!

 

[Joe Fallon]

You can play directly with the system tables if you really want to.
Pretty dangerous though. And not documented.

The tables are read only.
Queries based on them are read-write.

 

[Dean H.]

Thanks. I guess I will play it safe and us the wizard.

Dean H.

 

[John Nurick]

Hi Dean,

It might be worth considering using a schema.ini file for the
specifications: being a text file it can safely be edited by hand or
under program control. Schema.ini is documented very sketchily in Help
and more fully at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetsdk_98.asp

Search MSDN for "schema.ini" for even more information.

Thanks. I guess I will play it safe and us the wizard.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.