Need to edit ACCESS tables MSysIMEXColumns and MSysIMEXSpecs

[Joe Shapiro]

These tables I can not edit for some reason, but I need to
in order to import using the following method.

AccessApp.DoCmd.TransferText acImportDelim,
txtSpecName.Text, txtTable.Text, App.Path & "\" &
txtFile.Text

The txtSpecName.Text is the specification name in the
MSysIMEXSpecs table that tells ACCESS how to import the
text file.

I would like to be able to edit the tables for the import,
but they are presently Read only? Will I be able to edit
these tables??

 

[John Nurick]

Hi Joe,

These are system tables and it's normally not advisable to edit them.

You can create and save import specifications manually by clicking the
Advanced... button in the Text Import Wizard. If you need to generate
them under program control the best approach IMHO is not to, but instead
to generate a schema.ini file with the appropriate entries. This 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.

These tables I can not edit for some reason, but I need to
in order to import using the following method.

AccessApp.DoCmd.TransferText acImportDelim,
txtSpecName.Text, txtTable.Text, App.Path & "\" &
txtFile.Text

The txtSpecName.Text is the specification name in the
MSysIMEXSpecs table that tells ACCESS how to import the
text file.

I would like to be able to edit the tables for the import,
but they are presently Read only? Will I be able to edit
these tables??

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.