Editing Import/Export Specifications

  • Thread starter Thread starter Dean H.
  • Start date Start date
D

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!
 
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.
 
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.
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top