Modify Access Database Code To Modify

This time, those fields will be set as Indexed in the table design, even though the XML still says no index.

I no longer see this feature but hope that it still exists and has just been moved somewhere else.

However, if you are desparate, then under navigation options, select to show system objects.

Two tables are of interest here: MSysIMEXspecs and MSysIMEXColumns.

Not extensively tested by me, and obviously unsupported, but they ARE editable.

Try something like this: UPDATE MSysIMEXColumns SET FieldName LastName WHERE FieldName Field4 AND SpecID 5.

Thank you so much for this tip Im trying to find my way around a legacy access database and without this, it would take much longer to figure the imports out Thanks again.

Then cancel out of that import (that is not what you wanted anyway, right).

The third sub changes the name of an existing import specification.

The second sub allows you to change any xml text in the import spec.

This is useful if you need to change column names, data types, add columns, change the import file location, etc.

The first Sub is a routine that allows you to call an existing import spec, modify it for a specific file you are attempting to import, importing that file, and then deleting the modified spec, keeping the import spec template unaltered and intact.

Enjoy.

Public Sub fixImportSpecs(myTable As String, strFind As String, strRepl As String).

Public Sub MyExcelChangeName(OldName As String, NewName As String).

Modify Access Database Code To Modify

I added some code to modify the xml-object instead of replacing strings to change the path, I added the additional code in an answer below here.

Among other helpful tools it has a form to edit and save the ImportExport specifications.

Your question did not specify that, it only stated you had imported the data.

From there, simply click cancel, and you can now import any other similar data to various tables, etc.

Smandoli, seems like youre going around dropping useful points for no reason.

Also frustrated by the rigidity of the Saved Import system, I created forms and wrote code to pick apart the XML in which the Saved Import specs are stored, to the point that I could use this tool to actually create a Saved Import from scratch via coded examination of a source Excel workbook.

During the process, be sure to set Indexed to No for those columns.

Execute the import and check Save import steps in the final dialog window.

If you inspect the resulting table design, you will see there is no index on the field(s) in question.

Then delete the table, find the saved import and execute it again.

How To Modify Access Database