Hello!
I am importing two Excel 2007 files (Single tab worksheet) into two Access tables. It seems to work ok, but after the process runs Access creates a table named "Name AutoCorrect Save Failures" with the following entries:

Object Name Object Type Failure Reason Time
DASHBOARD_Import1 Table Could not save the object 11/7/2011 2:49:21 PM
DASHBOARD_Import2 Table Could not save the object 11/7/2011 2:49:24 PM


The following is the code i use to import the files:

Dim strfilepath1 As String
Dim strfilepath2 As String
Dim strrangename As String
Dim MySelection As String
Dim MySelection2 As String

DoCmd.SetWarnings False
DoCmd.Hourglass True
DoCmd.OpenQuery "qry_Delete_Import1"
DoCmd.OpenQuery "qry_Delete_Import2"

MySelection = Me.MySelections
MySelection2 = Me.MySelections2

strfilepath1 = "J:\Program Office\Performance Measurement\Reporting\BTS Weekly Meeting\Delta Analysis\" & MySelection
strfilepath2 = "J:\Program Office\Performance Measurement\Reporting\BTS Weekly Meeting\Delta Analysis\" & MySelection2

DoCmd.TransferSpreadsheet acImport, 8, "DASHBOARD_Import1", strfilepath1, True ', strrangename
WaitSeconds (2)
DoCmd.TransferSpreadsheet acImport, 8, "DASHBOARD_Import2", strfilepath2, True ', strrangename

Kill strfilepath1 & MySelection
Kill strfilepath2 & MySelection2

DoCmd.Hourglass False

Thanks for your help!
Gary